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
 
Read it again and maybe this is what you mean?

=IF(AND(TYPE(A1)=1,A1<>""),B1+C1,"")

Eg, Show the sum of the contents of B1 and C1 if A1 is a number and is not blank...

Not a pro in Excel, but I gather that this is what you mean? My previous post just assumed you were wanting your formula fixed, but if the number was less than 0.001 it wouldn't work... Hope I've understood correctly.
 
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