Hi
I currently using this formula
But what I would like is![]()
=IF(H113=H109,"Hours OK",IF(H113<H109,"Hours Under","Hours Over"))
=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
Bookmarks