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
Fenix internet on bank statement - Guide
An if statement nested within another if statement will produce how many possible results? - Guide
Logitech formula vibration feedback wheel driver - Download - Drivers
Excel grade formula - Guide
Number to words in excel formula - Guide

2 responses

Answer 1 / 2

Osama_bb11 Posts 21 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!

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

Similar discussions

Subscribe To Our Newsletter!