Anyone good with excel formulas?

Gav

Gav

Associate
Joined
21 Oct 2002
Posts
1,378
Location
Republic of Scotland
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
 
2nd one is the one i was after but 1 did the job as well.

Top Man. Been pulling my hair out for about an hour :)
 
Back
Top Bottom