PDA

View Full Version : [SOLVED] Problem wih logical es formula



blackie42
09-26-2014, 06:48 AM
Hi

I created the following formula in excel and it was working up until today - just can't figure out why it won't now. So in G1 I have..

=IF(E1="Open",(TODAY()-H1,"N/A")

H1 = date in the past, E1 = either Closed or Open (dropdown list)

Result was if Open - days between today and date in H1 showed in G1, If closed would be N/A

Not made any changes to the spreadsheet - any ideas why it stopped working - if not any other
method to get same result?

many thanks

ranman256
09-26-2014, 01:39 PM
too many left parens:

=IF(E1="Open",TODAY()-H1,"N/A")

blackie42
09-29-2014, 01:21 AM
Formula correct in excel - I just typed it wrong in the thread.

However it is working OK this morning - must have been a glitch in the office's excel system

thanks