#### steve400243

##### Active Member
Hello, I use this cell formula to return the data to cell A3 - "Received or Shipped" I also need ""Order" to populate if a date is entered into cell G3. and "Storage" to Populate if M3 >2. Changing each time new dates are entered in to cells D3, G3, and F3 and when cell M3 is greater than 2.

Hope that makes sense? Please let me know if you need additional information. Thank you for your time.

VBA Code:
``=IF(D3="","",IF(F3="","Received","Shipped"))``

#### steve400243

##### Active Member
The reason you are getting #Name is that the IFS function is only available in 2019 & 365.
Excel Formula:
``=IF(D3="","",IF(F3<>"","Shipped",IF(G3<>"","Order",IF(M3>2,"Storage","Received"))))``
Ah ok, Thank you! Would the same be used for the Formula in Cell N2?
 VBA Code: ``=IFS(M3<2,0,A3="shipped",F3-D3-2,A3="storage",\$B\$1-D3-2)``

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

#### Fluff

##### MrExcel MVP, Moderator
You will need to change that to nested if functions.

#### steve400243

##### Active Member
You will need to change that to nested if functions.
Thank you again, I truly appreciate the help, and thanks for the tips on my account updates.

#### Crystalyzer

##### Well-known Member
The reason you are getting #Name is that the IFS function is only available in 2019 & 365.

#### Fluff

##### MrExcel MVP, Moderator
Maybe you missed
I'm Using 2016, will update my account details, my apologies.
Also the formulae shown in post#8 are a giveaway that the OP doesn't have IFS

Replies
5
Views
110
Replies
1
Views
71
Replies
9
Views
155
Replies
2
Views
85
Replies
0
Views
118

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,152,482
Messages
5,770,349
Members
425,612
Latest member
martinijr

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