At work, need help with formula!
Okay, so I'm stuck working with Excel 2003. I'm trying to get one cell to auto fill with the date and another with the current time when something is scanned into the spreadsheet. I keep getting circular reference issues/errors and the formulas break. The one I've been using for the date is this one, time is basically the same only NOW:
=IF(B137<>"",IF(C137="",TODAY(),C137),"")
Help please, I'm tied up with other things and don't have forever to search and find formulas more problematic in this old version than what I'm used to working with...
IF formula
Hi
your formula is fine.
- it shows C137 value if B137 & C137 aren't empty,
- it shows today's date if B137 is not empty but C137 does.
either
- it shows nothing if both B137 is empty
problem must from something else.
Ya, I figured it out
Ya, I figured it out finally....in the calculation settings there was a 100 iterations limit to circular references - bumped it up to 10000 so should be good to go for awhile.