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

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

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1