excel formula question

[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

 

[Niek Otten]

Hi Krien,

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

 

[k.vangeffen]

Hi Niek,

Yep it works!
Thanks a lot