# combining if statements

#### mmstat

##### New Member
Can you help with these if statments?

q1:
D2=A2-B2.
I want any answer in D2 that is a negative number to be recoded as a 0
I would like to do this in 1 column (D)

q2:
if inventory at end of the day is 0, order 4
if inventory at end of the day is 1, order 3
else do not order
e4 contains the following equation
= IF( D2=0, E2=4, IF(D2=1, E2=3, E2=A2) )
I am getting all zeroes.

Thanks.

### Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

#### Norie

##### Well-known Member
Q1 =MAX(0, A2-B2)

Q2 not quite sure what you mean, but you can't use a formula in E4 to put a value in E2.

E2=4, E2=3 and E2=A2 will return either true or false - in the cell the formula is in, ie E4.

#### mmstat

##### New Member
Thank you for your reply. I figured out the solution for q2.

Solution:
= IF( D2=0, 4, IF(D2=1, 3,0) )

mmstat

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,164,445
Messages
5,837,281
Members
430,493
Latest member
CPG2970

### 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