Excel formula problem

[slickp]

Really scilly question that i should know answer to but the heat has frazzled my brain!!

I've got an IF formula in Excel and I want to know if this cell or another cell is greater than a certain number then yes or no.

I would write it as this:

=IF(D23 or D24>=2500000, "YES", "NO")

but it doesn't work. Anybody help?

 

[Loomah]

hi
you're nearly there

=if(or(d23>999,d24>999),"yes","no")

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[AnotherHiggins]

Your syntax for OR is wrong.

Try this:
[tab]=IF(OR(D23>=2500000,D24>=2500000), "YES", "NO")

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[slickp]

Cheers thats great!!

Should have known that answer but having one of those days!!