I have this formula which works perfectly..
=IF(ISERROR(P6-8.5)," ",(IF(P6>8.5,P6-8.5,"")))
but i now need to cap the second half of the formula..so if P6 is greater than 8.5, it does P6-8.5.. but it doesn't return a result that is greater than 1
I have this formula which works perfectly..
=IF(ISERROR(P6-8.5)," ",(IF(P6>8.5,P6-8.5,"")))
but i now need to cap the second half of the formula..so if P6 is greater than 8.5, it does P6-8.5.. but it doesn't return a result that is greater than 1
Last edited by MJLG; 02-01-2018 at 06:37 AM.
Hi
What you want if P6 < 8.5 ?
May be
=IF(ISERROR(P6-8.5)," ",(IF(P6>8.5,P6-8.5,P6)))
Try
=IF(ISERROR(P6-8.5)," ",(IF(P6>8.5,MIN(1,P6-8.5),"")))
but not sure about the IFERROR
perhaps
=IF(P6=""," ",IF(P6>8.5,MIN(1,P6-8.5),""))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks