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
Please Login or Register to view this content.
---
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