Hi Everyone
is it possible to set a max value within an IF loop.
=IF(P6=11,MAX(40,Y6-T6),"N/A")
formula i sued
Y6 = 92
T6 = 42
when i run the above formula i should get 40, instead im getting 50, how to overcome this problem?
Hi Everyone
is it possible to set a max value within an IF loop.
=IF(P6=11,MAX(40,Y6-T6),"N/A")
formula i sued
Y6 = 92
T6 = 42
when i run the above formula i should get 40, instead im getting 50, how to overcome this problem?
Maybe this way (use code delimiters when entering code or formulas
=IF(P6=11,MAX(40,VALUE(Y6-U6)),"N/A")
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Shoudln't you be using MIN instead of MAX ? if the difference exceeds 40 it will then return 40. If not, the result will be returned
True, True I overread that
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks