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

2 replies

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())
0
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!
0