2 cells 1 formula

[Bob]

1st, Thanks for the help....

I have this simple formula
if(a1=" ",a1,if(a1=>1,5))

I put this formula in cell c3 and it works, if a1 is blank then c3
turns blank, and if cell a1 is 1 or more c3 turns 5.
Now I want to do the same adding cell b1 and a1 leaving this formula
in cell c3, like this, if cells a1 & b1 are blank then c1 turns
blank. and if either a1 or b1 has a value say #1 then c1 turns 5.
Every formula I write if a1 or b1 is blank and the other has a number
I get a VALUE error which I understand, but can't figure how to write
the formula.

Thanks -a- bunch
Bobby

 

[Nick Hodge]

Bob

=IF(AND(A1="",B1=""),"",IF(OR(A1=>1,B1=>1),5,""))

You typed formula appears to have a space between the " ". If you are
testing for blank cells you should have no space ""
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Bob]

Thanks Nick, looks so easy... but...
Bobby

 

[Sandy Mann]

Just for the archives because I know that you know but * A1=>1,B1=>1 *
should be * A1>=1,B1>=1 *

--
HTH

Sandy
In Perth, the ancient capital of Scotland

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Nick Hodge]

Sandy

That'll teach me! ;-) Thank you

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)