excel formula question

K

k.vangeffen

Hello,

Question:
I've got this formula; =OR(AND(E2-G2>1000;E2-H2>500);(AND(G2=0;H2=0)))
And it works great, the problem is I do not want the true or false
answer but want to personalize it.
As far as I get it I need to put at the end of the formula someting
like; (, "ok", "to big")
What ever, the answer is in dutch so it wouldn't help you a lot..
Can comeone please help me??

Regards,

Krien
 
N

Niek Otten

Hi Krien,

=IF(OR(AND(E2-G2>1000,E2-H2>500),(AND(G2=0,H2=0))),"VooruitDanMaar","Te
Heftig")
 
Top