How can I please edit the below formula to display a fixed maximum number of 288.6 if the formula result were above 288.6.
=IF(H10="","",IF(MIN(S10,U10)<H10,FALSE,MIN(S10,U10)))
How can I please edit the below formula to display a fixed maximum number of 288.6 if the formula result were above 288.6.
=IF(H10="","",IF(MIN(S10,U10)<H10,FALSE,MIN(S10,U10)))
=iferror(min(if(h10="","",if(min(s10,u10)<h10,false,min(s10,u10))),288.6),"")
Gary's Student
Unfortunately when using your suggested formula, I had the following message:
Invalid Formula
The formula you entered is invalid.
Please fix the formula and try again
Last edited by Khaldon; 04-06-2014 at 12:15 PM.
If possible please to use other than IFERROR function, maybe IFERROR is not supported function by my apple app.
Maybe this...
=IF(H10="","",IF(MIN(S10,U10)<H10,FALSE,MIN(288.6,S10,U10)))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks