Nested formula with 'or' statement

Closed

jutulu

Posts: 34
Registration date: Monday March 10, 2014
Status: Member
Last seen: September 21, 2015

- Jun 16, 2014 at 04:44 PM
jutulu

Posts: 34
Registration date: Monday March 10, 2014
Status: Member
Last seen: September 21, 2015

- Jun 22, 2014 at 07:10 PM

Hi,
I have formula IF(ISBLANK(A3)," ", C3-TODAY()), which works absolutely fine but and i want to include another argument on it so that if value in cell C3, which the date, is less that today's date D3 to be blank. I have tried =IF(OR(C2<TODAY(),ISBLANK(A2)," "), C2-TODAY()), but it returns a NAME error. Appreciate your help with this

Nested formula with 'or' statement
An if statement nested within another if statement will produce how many possible results? - Guide
Excel data validation formula if statement - Forum - Excel
Nested If Statement not working ✓ - Forum - Excel
Formula to add 1 with IF statement ✓ - Forum - Excel
EXCEL: Nested IF formula question ✓ - Forum - Excel

2 replies

Answer 1 / 2

Osama_bb11

Posts: 22
Registration date: Sunday May 25, 2014
Status: Member
Last seen: September 25, 2014

Jun 17, 2014 at 02:00 AM

Hi Dear,

please try this

=IF(OR(C2<TODAY(),ISBLANK(A2)),"",C2-TODAY())

Answer 2 / 2

jutulu

Posts: 34
Registration date: Monday March 10, 2014
Status: Member
Last seen: September 21, 2015

2
Jun 22, 2014 at 07:10 PM

It works absolutely great? Many thanks!

Subscribe To Our Newsletter!