excel formula question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

k.vangeffen - 16 Jan 2006 18:04 GMT

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

Reply to this Message

Niek Otten - 16 Jan 2006 18:37 GMT

Hi Krien,

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

Signature

Kind regards,

Niek Otten

> Hello,
>
[quoted text clipped - 10 lines]
>
> Krien

Reply to this Message

k.vangeffen - 17 Jan 2006 18:56 GMT

Hi Niek,

Yep it works!
Thanks a lot

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

Reply to this Message