Hi there,
Am designing a timseheet spreadsheet and am finding myself a bit stuck on one issue, namely:
In cell H35 of the spreadsheet will be displayed a number. If this number if 0-6.99 it should be displayed in the cell as "!!!", if it is 7-8 as "OK", if 8.01-10 as " OK ", and then anything above 10.01 as "!!!".
This is fine, But I have one complicating factor, namely that if in Cell H27 is displayed the number 7.5 (and only 7.5), then in H35 should automatically be displayed "!!!".
Any suggestions much appreciated!!
Andy
Bookmarks