combining if statements

mmstat

New Member
Joined
Aug 1, 2010
Messages
2
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
Joined
Apr 28, 2004
Messages
76,344
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Aug 1, 2010
Messages
2
Thank you for your reply. I figured out the solution for q2.

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

mmstat
 
Master Excel Bundle

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.

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top