if statement multiplying when the number is positive

**fernandosaez** · 01-26-2011, 04:55 PM

Please help with this if statement.

I need c3 to multiply by c2 if the number is positive. In the actual case with a -13,642,000 the rsult in c3 should be 0. If it were 100 it would be -17 since it is a tax.

Help?

**Cutter** · 01-26-2011, 05:48 PM

I think this is what you mean:

In C3 place this formula: =IF(C2>0,C2*0.17,"")

change the double " at the end to whatever you want when C2 is NOT > 0

**DonkeyOte** · 01-26-2011, 06:02 PM

Originally Posted by fernandosaez

in the actual case with a -13,642,000 the rsult in c3 should be 0. If it were 100 it would be -17 since it is a tax.

Assuming you mean 17 rather than -17 I would suggest:

Please Login or Register  to view this content.

If not change 0.17 to -0.17 and MAX to MIN.

note: you may need to revert , to ; pending your regional settings

**fernandosaez** · 01-26-2011, 06:27 PM

Originally Posted by Cutter

I think this is what you mean:

In C3 place this formula: =IF(C2>0,C2*0.17,"")

change the double " at the end to whatever you want when C2 is NOT > 0

Great!

One thing, It returns a NOT > 0 or anything I change it to. Can it in some way return to the number 0?

**Cutter** · 01-26-2011, 06:39 PM

You were supposed to replace the "" with whatever you wanted so:

=IF(C2>0,C2*0.17,0)

but following DonkeyOte's advice would be the better way to go.

**fernandosaez** · 01-27-2011, 09:43 AM

Originally Posted by Cutter

You were supposed to replace the "" with whatever you wanted so:

=IF(C2>0,C2*0.17,0)

but following DonkeyOte's advice would be the better way to go.

Max and Min didnt work cause it just gives positive and negative numbers. What you said worked perfect. THANKS!

**Cutter** · 01-27-2011, 09:53 AM

You're welcome.

But the formula that DonkeyOte gave you (in Post #3): =MAX(0,C2*0.17)
will give you the exact same results.

Anyway, don't forget to mark your thread as SOLVED (click FAQ in menu bar at top of this page for directions)