"IF"

[ajanderson]

What formula would I use to get the following:

<!--= 0, then put 0 in cell d8, but if the number in cell b8 is --> For cell d8: If the number in cell b8 is greater than or equal to 0, put that number in cell d8, but if the number in cell b8 is less than or equal to 0, put 0 in cell d8.

 

[pgc01]

Hi ajanderson
Welcome to the board

Try in D8:

=MAX(B8,0)

 

[Mel Smith]

Hi and welcome to the Board.

Try this formula in cell D8: =IF(B8>=0,B8,0)

I hope this helps.

Mel