Adding to an IF Statement or change to IFS statement

**Stenner** · 12-10-2021, 04:44 AM

Hi,

I have an IF formula to work out the numbers of days late (or early) an order is compared to the first date I confirmed back to the customer.
I ran into a problem where an order has a confirmed date but no current in stock date. Numerous reasons why this happens but I can't figure out how to either nest my current IF statement or change it to an IFS statement to include a condition that if there is a First confirmed date (column D) but no Current in stock (column C) that it should return a blank.

Any help on this is much appreciated. Sample book attached.

**TMS** · 12-10-2021, 04:49 AM

Try

Formula:

Please Login or Register  to view this content.

**JohnTopley** · 12-10-2021, 04:50 AM

Try

=IF(C2="","",IF(D2<>"",SUM(C2-D2),""))

**Stenner** · 12-10-2021, 04:58 AM

Both formulas worked perfectly, thank you

!

**TMS** · 12-10-2021, 05:00 AM

Or

Formula:

Please Login or Register  to view this content.

but I prefer to check for the equals condition.

Note that you don't need the SUM round the calculation. But you could have

Formula:

Please Login or Register  to view this content.

**TMS** · 12-10-2021, 05:01 AM

You're welcome.

Adding to an IF Statement or change to IFS statement

LinkBack

Thread Tools

Rate This Thread

Display

Adding to an IF Statement or change to IFS statement

Re: Adding to an IF Statement or change to IFS statement

Re: Adding to an IF Statement or change to IFS statement

Re: Adding to an IF Statement or change to IFS statement

Re: Adding to an IF Statement or change to IFS statement

Re: Adding to an IF Statement or change to IFS statement

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Adding another IF statement

[SOLVED] Adding an IF statement into an existing IF OR statement

[SOLVED] Adding OR statement into If statement

Adding CountIf Statement within If/ElseIf Statement

Change IF, THEN, ELSE statement to a count statement

Adding an OR statement for a value

IF Statement + adding

Bookmarks

Bookmarks

Posting Permissions