IF statement
 

I am not sure what to do here.
I have a worksheet and if C29 - C26 =0, I want the cell to dispay the
amount (for example 20000 - 15000= 50000) but if it is <=0, I want the cell
to display 0.

Can I use an IF statment for this? How would I do this?

thanks!

IF statement
 

Hi,

You could use IF but don't need it, try this

=MAX(0,C29-C26)

Mike

"help!" wrote:

I am not sure what to do here.
I have a worksheet and if C29 - C26 =0, I want the cell to dispay the
amount (for example 20000 - 15000= 50000) but if it is <=0, I want the cell
to display 0.

Can I use an IF statment for this? How would I do this?

thanks!

IF statement
 

try this

=IF((C29-C26)=0,C29-C26,0)



On Sep 19, 1:06*am, help! wrote:
I am not sure what to do here.
I have a worksheet and if C29 - C26 =0, I want the cell to dispay the
amount (for example 20000 - 15000= 50000) but if it is <=0, I want the cell
to display 0.

Can I use an IF statment for this? How would I do this?

thanks!

IF statement
 

You could also try

=(C29C26)*(C29-C26)

The equation in first set of brackets returns 1 if true, 0 if false, and
the equation in the second set of brackets is multiplied by that value

Boatman

"help!" wrote:

I am not sure what to do here.
I have a worksheet and if C29 - C26 =0, I want the cell to dispay the
amount (for example 20000 - 15000= 50000) but if it is <=0, I want the cell
to display 0.

Can I use an IF statment for this? How would I do this?

thanks!

IF statement
 

Thanks this worked for the one cell, however when I used it another cell to
show the increase for example =IF((C29-C26)<=0,C29-C26,0)

it returns the correct amount but with a negative sign in front. How do I
get rid of the negative sign?

thanks!

"muddan madhu" wrote:

try this

=IF((C29-C26)=0,C29-C26,0)



On Sep 19, 1:06 am, help! wrote:
I am not sure what to do here.
I have a worksheet and if C29 - C26 =0, I want the cell to dispay the
amount (for example 20000 - 15000= 50000) but if it is <=0, I want the cell
to display 0.

Can I use an IF statment for this? How would I do this?

thanks!

IF statement
 

Well, if your current formula is returning a result of C29-C26 and that is
negative, what do *you* think the formula is which would give a positive
number of the same magnitude?
--
David Biddulph

"help!" wrote in message
...
Thanks this worked for the one cell, however when I used it another cell
to
show the increase for example =IF((C29-C26)<=0,C29-C26,0)

it returns the correct amount but with a negative sign in front. How do I
get rid of the negative sign?

thanks!

"muddan madhu" wrote:

try this

=IF((C29-C26)=0,C29-C26,0)



On Sep 19, 1:06 am, help! wrote:
I am not sure what to do here.
I have a worksheet and if C29 - C26 =0, I want the cell to dispay the
amount (for example 20000 - 15000= 50000) but if it is <=0, I want the
cell
to display 0.

Can I use an IF statment for this? How would I do this?

thanks!