Hi, I have a formula which is =IFERROR(IF(F9*1>5,"",6-(F9*1)),""). I have recently spotted that there is one situation which doesn't works in that when a cell value is 0 in F9, this needs to return a blank cell.
I can see that the latter part of the formula shows a calculation thus : 6-(0*1) which returns a 6 but the formula needs modifying slightly to facilitate this condition to return a blank cell when 6 and above are the cell values.
NB the formula works fine for cells values from 1,2,3,4 and 5 showing values of 5,4,3,2 and 1 respectively, and a blank cell for all other figures/letters apart from the one problem above so its really an addition to this formula which I need help with please to finish this spreadsheet.
Many thanks for a solution
Andy
Bookmarks