=IF(EX84="John Doe",(EZ84*FH84/1.7475), (EZ84*FH84/2.995))
That was my initial function - now I also need it to be, if FH=137.75 then 50. How do I tack this on - please show the whole function.
Thank you!
=IF(EX84="John Doe",(EZ84*FH84/1.7475), (EZ84*FH84/2.995))
That was my initial function - now I also need it to be, if FH=137.75 then 50. How do I tack this on - please show the whole function.
Thank you!
Last edited by rcrhymes123; 07-13-2011 at 01:32 PM.
When does that take affect within the logic?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
I would think last.
Can you spell out the logic of the whole function in words? It can't just be last...
These are payments to sales reps. So it's saying if it's John Doe in cell EX84, then he gets money(EZ84)*Quantity/1.7475) - which happens to be $100. If it's anyone else, they get money(EZ84*Quantity/2.995). But now there is also a case where if EZ84 ever equals $137.75, then the sales rep gets $50. Does that make sense?
I don't know if "or" is allowed. But I could also use this function and have =IF(EX84="John Doe",(EZ84*FH84/1.7475), and then if FF84=399 or 375, 50 and then after that it'd need to show 0 if FF was 0.
Still confusing logic... but perhaps:
=IF(EZ84=137.75,50,IF(EX84="John Doe",(EZ84*FH84/1.7475), (EZ84*FH84/2.995)))
Well, of course I thought I tried that, but I must have done it wrong. Because yours worked and mine didn't. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks