Where do I go wrong?

[momchil.vladov]

I've done this simple formula many times. It worked before. I've changed MS Office form 2010 to 2013 and now it won't work.
I'm attaching an exemple.

The formula: D2=IF(AND(D1<=0);(D1*0));IF(AND(D1>0);(D1*25%))

If I insert only D2=IF(AND(D1<=0);(D1*0)) it works. It makes D2=0
If I insert only D2=IF(AND(D1>0);(D1*25%)) it works. It makes it the right amount.

Where the **** I go wrong? Damn I'm mad with myself!

[JohnTopley]

In your workbook you have a note relating to Conditional Formatting but you post above relates to a formula in D2 which does not correlate with your file.

Confused

Perhaps

=IF(D1<=0,0,D1*25%)

[momchil.vladov]

sorry. wrong file.

[JohnTopley]

Not sure why you have the AND in your formula

This should suffice

=IF(D1<=0,0,D1*25%)

[TMS]

You don't need the ANDs. For example:

Please Login or Register  to view this content.

Regards, TMS

[momchil.vladov]

=IF(D1<=0; 0; D1*25%)

That worked. Thank you very much.

[Khalidngo]

Hi momchil.vladov,
You dont need AND, nor IF:

=MAX(0,D1)*25%

Blessing

[TMS]

See the attached: