× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
5
a
5
k
5
c
5
B
5
l
5
C
4
s
4
a
4
t
4
i
4
r
4
New Topic  
JrobJrob JrobJrob
wrote...
Posts: 442
Rep: 0 0
6 years ago
You are trying to assess the performance of your North American branches. The performance measure is gross profit. The relevant figures are contained in the Gross Profit field. If Gross Profit is greater than or equal to 55, the custom field, named Status, will read Approve. If Gross Profit is between 54 and 30, the custom field will read Attention. If Gross Profit is less than 30, the field will read Fail. What is the field name that will be entered?
 
  A) IIf(Gross Profit >=55, Approve, IIf(Gross Profit >=30, Attention, Fail))
  B) IIf(Gross Profit >=55, Approve, IIf(Gross Profit >30, Attention, Fail))
  C) IIf(Gross Profit >=55, Approve, >30, Attention, Fail)
  D) IIf(Gross Profit >=55>30, Approve, Attention, Fail)
Read 63 times
1 Reply
Replies
Answer verified by a subject expert
kodama55kodama55
wrote...
Top Poster
Posts: 779
6 years ago
Sign in or Sign up in seconds to unlock everything for free
1

Related Topics

JrobJrob Author
wrote...

6 years ago
This site is awesome
wrote...

Yesterday
Thank you, thank you, thank you!
wrote...

2 hours ago
I appreciate what you did here, answered it right Smiling Face with Open Mouth
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers
  1230 People Browsing
 101 Signed Up Today
Related Images
  
 978
  
 806
  
 569