× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
A
6
j
6
c
5
m
5
C
5
d
5
s
5
n
4
i
4
d
4
d
4
J
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 65 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 calls for a celebration Person Raising Both Hands in Celebration
wrote...

Yesterday
Thanks for your help!!
wrote...

2 hours ago
This helped my grade so much Perfect
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers
  894 People Browsing
 106 Signed Up Today
Related Images
  
 640
  
 370
  
 814
Your Opinion
Where do you get your textbooks?
Votes: 422

Previous poll results: What's your favorite math subject?