# "IF"

#### ajanderson

##### New Member
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.

Last edited:

### Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

#### pgc01

##### MrExcel MVP
Hi ajanderson
Welcome to the board

Try in D8:

=MAX(B8,0)

#### Mel Smith

##### Well-known Member
Hi and welcome to the Board.

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

I hope this helps.

Mel

Replies
3
Views
39
Replies
16
Views
182
Replies
7
Views
222
Replies
3
Views
76
Replies
13
Views
95

1,191,517
Messages
5,987,057
Members
440,074
Latest member
Emmanuelian

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back