IF Function


I'm super stumped! I'm still pretty new at Excel and am having a problem with writing out this formula correctly and I have spent many hours and still can't come up with the correct calculations for the formula. EX: . Gwen offers a $5.00 discount to repeat students. Apply this discount as appropriate to the student data as follows:
In cell H4, create a formula using the IF function and structured references to determine the correct amount paid based on the following criteria:
a. If the Repeat? value is “Yes”, calculate the amount paid by subtracting 5 from the Fee.
b. Otherwise, the amount paid is the Fee value.

4 Replies

That's like

= <Fee> - 5*(<Repeat?> = "Yes")
If you prefer the IF version of the Boolean formula, it is this:
=IF(<Repeat?> = “Yes”,
<Fee> - 5,


= <Fee> - IF(<Repeat?> = "Yes",5)
You make me smile with your creative use of the IF, Sergei!
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
18 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies