IF...

[Meredith]

Over the Labor Day weekend, I copied an IF formula from my father's
Windows woksheet, but this formula is not working on my Mac.

Here is the formula: if(K6>L4,(.15*(min(K6,M4)-L4),0)

K6 = $20,000
L4 = $7,825
M4 = $31,650

As you've probably guessed, this is a tax worksheet and all I get for
a response is the formula, not a number, Putting an equal sign in
front only gets me a error message.

Does anyone have any ideas about what the problem might be? Math is
not one of my strong points, but even I can copy a formula and fill in
the blanks.

Thanks in advance,

Meredith

 

[CyberTaz]

Hi Meredith -

See if this gives the right result (1826.25 based on your values?):

=IF(K6>L4,0.15*((MIN(K6,M4))-(L4)),0)

I'm assuming L4 needs to be subtracted from the lesser of K6,M4 and the
result multiplied by .15 - Also, the = has to be there. Otherwise Excel sees
the entry as a text string, not as a formula.

 

[JE McGimpsey]

Just an alternative (assuming Bob's correct in *his* assumptions):

=(K6>L4)*0.15*(MIN(K6,M4)-L4)

 

[Phillip Jones]

try:
=if(K6>L4,(.15*(min(K6,M4)-L4),0)) I don't if I have right best I can
remember you don't have a legitimate formula unless the starts with the
= symbol

Over the Labor Day weekend, I copied an IF formula from my father's
Windows woksheet, but this formula is not working on my Mac.

Here is the formula: if(K6>L4,(.15*(min(K6,M4)-L4),0)

K6 = $20,000
L4 = $7,825
M4 = $31,650

As you've probably guessed, this is a tax worksheet and all I get for
a response is the formula, not a number, Putting an equal sign in
front only gets me a error message.

Does anyone have any ideas about what the problem might be? Math is
not one of my strong points, but even I can copy a formula and fill in
the blanks.

Thanks in advance,

Meredith

--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>

 

[Meredith]

Over the Labor Day weekend, I copied an IF formula from my father's
Windows woksheet, but this formula is not working on my Mac.

Here is the formula: if(K6>L4,(.15*(min(K6,M4)-L4),0)

K6 = $20,000
L4 = $7,825
M4 = $31,650

As you've probably guessed, this is a tax worksheet and all I get for
a response is the formula, not a number, Putting an equal sign in
front only gets me a error message.

Does anyone have any ideas about what the problem might be? Math is
not one of my strong points, but even I can copy a formula and fill in
the blanks.

Thanks in advance,

Meredith

greetings again,

i made the changes that CyberTaz recommended. however, i get a
negative number answer, which won't work on a tax sheet. but we're
heading in the right direction as it is a number rather than a formula
this time.

thanks,
meredith

 

[JE McGimpsey]

i made the changes that CyberTaz recommended. however, i get a
negative number answer, which won't work on a tax sheet. but we're
heading in the right direction as it is a number rather than a formula
this time.

If you don't want negatives, one way:

=MAX(0,0.15*(MIN(K6,M4)-L4))*(K6>L4)