Need a =NOW() function added to the =MAX function to calculate a value if cell is blank

[jandtng]

If Column B is blank, Column C return 0.0
Is there a way to add an =IF function to the =MAX function to use today's date and time to calculate for Column C if Column B is blank? Thanks!

 

[etaf]

=if( B2="",Max(0, Now()-A2) ,Max(0,B2-A2) )
replaces your blank B
various ways to that , I just took the mAX vlaue at face value rather then look at other ways

 

[jandtng]

=if( B2="",Max(0, Now()-A2) ,Max(0,B2-A2) )
replaces your blank B
various ways to that , I just took the mAX vlaue at face value rather then look at other ways

Outstanding! Thanks a bunch!

 

[etaf]

you are welcome