Forum Discussion
Help with Excel functions
Hello Community, I'm in desperate need of help with a problem for my accounting class. I've attached the file. The problem is: In cell H6, enter a formula to determine any discount that should be ap...
Hello Yasmin,
For H6, you may use any of these formulas:
1. IF function: =IF(OR(F6={"Express Miles","Rewards"}),
E6*G6*Discount,
0)
2. Boolean formula: =OR(F6={"Express Miles","Rewards"})*
E6*G6*Discount
You can then copy your chosen formula down to H32.
Cheers!
Twifoo
Plkease explain. How would "number of rentals" be words?
