I need to get a formula which will look at a cell and decide if it has a number in it before it decides what to place in its own cell.. eg
if (cell a1>=0.001 then use this formula(b1+c1) if it isn't >=0.001 then show nothing)
this is assuming that the formula is contained in cell d1.
I have tried this but the =b1+c1 part shows up as text.
=IF(A1>=0.001,"=B1+C1","")
Can anyone help ?
TIA
Gav
if (cell a1>=0.001 then use this formula(b1+c1) if it isn't >=0.001 then show nothing)
this is assuming that the formula is contained in cell d1.
I have tried this but the =b1+c1 part shows up as text.
=IF(A1>=0.001,"=B1+C1","")
Can anyone help ?
TIA
Gav