# excel formula question

1. ## excel formula question

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")

Regards,

Krien  Register To Reply

2. ## Re: excel formula question

Hi Krien,

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

--
Kind regards,

Niek Otten

"k.vangeffen" <krienv@yahoo.com> wrote in message
news:be23d\$43cbe028\$50381751\$15860@news.chello.nl...
> 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")
>
> Regards,
>
> Krien  Register To Reply

3. ## Re: excel formula question

Hi Niek,

Yep it works!
Thanks a lot

Niek Otten wrote:
> Hi Krien,
>
> =IF(OR(AND(E2-G2>1000,E2-H2>500),(AND(G2=0,H2=0))),"VooruitDanMaar","Te
> Heftig")
>
>  Register To Reply