Forum Discussion
yasmin walker
Apr 07, 2018Copper Contributor
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...
SergeiBaklan
Apr 07, 2018Diamond Contributor
That could be like
=IFERROR(IF(OR(F6="Express Miles",F6="Rewards"),VLOOKUP(A6,RentalRates,2,FALSE),0),0)
yasmin walker
Apr 07, 2018Copper Contributor
Thank you for your response. I hope I have some luck.