Formula return statements on multiple criteria

Hi

I currently using this formula

Please Login or Register  to view this content.

But what I would like is

=IF(H113 is within 5% of H109,"Hours OK",IF(H113 is over 5% under or over 5% over H109,"Hours Under","Hours Over"))

Hope above makes sense.

I could probably do it with helper columns but unfortunately sheet is already completed and cant really add columns as it mess up rest of sheet.

Thanks in Advance

Originally Posted by TMS

Maybe:

Formula:

Please Login or Register  to view this content.

Regards, TMS

Thanks but it works as in no errors but it returns wrong results. Probably my explaining. Will try and break it down

If H109 = 100 and H113 as hours between 95-105 (h% Over\Under) and like it to return hours OK. If H113 has hours 95 or under it return "Hours Under" or Hours 105 and over it return "Hours Over"

=IF(AND(H113>=95%*H109,H113<=105%*H109),"OK",IF(H113<95%*H109,"Under","Over"))