example:If Statement

[born2rade2]

Hello

I have an if statement for example. if a number equals a -1 than make this cell 0.

=IF(E31=-1, 0)

The other cells that do not have a negative number are just multiplying two cells like this

=Sum(E32*G32)

Bascialy what i want is to combine these two statements together. For example if that IF statement is False than i want it to Equal the =Sum statement.

Also i have another question. instead of typing -1 or -2 is there a way to make it where if it equals ANY negative number?

[DonkeyOte]

How about

=E32*G32*(E31>=0)

Or... in IF terms

=IF(E31>=0,E32*G32,0)

[born2rade2]

well it worked for sure! lol. Thanks.

I don't know why i did not think of using greater than less than. That makes complete sense.

Thank you very much.