I am trying to generate a result of Yes or No based on 3 criteria being met. For some reason my calculation will not work. See attached. The argument is as follows:
If the spend in Month 1, 2 and 3 are below $50 then the answer is Yes "Y", otherwise it is No "N".test calc multiple if.xlsx
Thanks in advance!
try OR instead of AND
=IF(OR(F5<$E$2,H5<$E$2,J5<$E$2),"N","Y")
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Hiii..
find the attached sheet...I hope this helps..
You can add reputation(s) of those who helped
Try ..
=if(and(f5<$e$2, h5<$e$2, j5<$e$2),"y","n")
In your file all cases result in "N": I don't understand how you get "Y" for your expected results.
Last edited by JohnTopley; 10-21-2015 at 03:06 AM.
Thank you. Using the "OR" function vs. "AND" worked perfectly!
Last edited by Perk1961; 10-21-2015 at 09:05 AM.
Beaten to the punch re SOLVED
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks