If function

[JulesV]

I have an "if formula" that relies on a cell that contains a formula how can I get the cell to show blank. This formula is in J10 =IF(I10>7,I10-7,IF(I10<7,I10-7,"")) where I10 has a formula eg h10-g10 and I want J10 to remain blank until content is entered into other cells in row 10.

 

[cb12]

Try: =IF(I10="","",IF(I10>7,I10-7,IF(I10<7,I10-7,""))) however if I10 = 7 then as it currently stand it will also return blank. If this is an issue you'll need to correct as appropriate

 

[JulesV]

Thanks, but it is still coming up with a value error

 

[cb12]

Then the likely issue is that either H10 or G10 are not numeric. Beyond that I don't know. Sorry