I am using a formula like this:
IN CELL B1 =IF(A1>0;NOW();0)
IN CELL B2 =IF(A2>0;NOW();0)
IN CELL B3 =IF(A3>0;NOW();0)
And so on...
And "A:A" has various calculations that return a number.
The problem I run into is, when ONE of the "B:B" cells returns a Date/Time result, they all return the same exact Date/Time result. But I'm trying to get different date/time results row by row. So, how do I get individual results?... if there is no other way besides VBA, then please provide a VBA for me.
Thanks!
Bookmarks