I am setting up a spreadsheet in Excel 2007 and in cell F7 I have the
following formula : =IF(D7<0,(SUM(D7-C7,1)/5),("")) in order that nothing
will show up in that cell until a number is put into D7 - if I don't use the
IF function I get a value of 0.2 in the cell, which I obviously don't want.
The formula in D7 is to subtract C7 from D7, add 1 and then divide the total
by 5.
However, I then need to multiply the value of F7 by 5 again, this time in G7
but neither the IF or ordinary SUM formulas will return anything but the
dreaded #VALUE.
Can someone point out were I am going wrong - I am sure it must be glaringly
obvious but I am stuck!
Thanks
Nick