IF THEN formula help
I think I need an IF THEN formula, but it seems like it could be much simpler. However, I'm not great at Excel and I've been trying to input the correct formula for days to no avail.
Basically: IF K9<=1.15, then Q9=1.15, IF K9>=1.50, then Q9=1.50, however, if K9 is any number in between 1.15 and 1.50, then that number is acceptable in Q9
Thank you for any help.
Heather
Ty:
=IF(K9>=1.50,1.50,IF(K9>1.15,Q9,1.15))
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.
How about..in Q9
=MIN(MAX(K9,1.15),1.5)
Last edited by Ace_XL; 08-21-2013 at 02:13 PM.
Life's a spreadsheet, Excel!
Say thanks, Click *
Thank you NBVC. That puts me closer, but not quite right on. That formula changes the result in Q9 to 1.15, when the number currently in K9 is 1.29 and therefore acceptable. If you have another suggestion, I am grateful. However, I will continue to work with the formula you have given me.
Thank you again
Heather
Sorry, the Q9 in the formula should be K9
=IF(K9>=1.5,1.5,IF(K9>1.15,K9,1.15))
Those worked, thank you both so much. I can't believe I worked on this for hours when the answer was a minute away.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks