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
Date formula in excel dd/mm/yyyy - 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

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!