How do i calculate a formula based on a time and making money due.
Quote from a prev. post
"want the value in a cell to be a calculated value if the date of viewing the value is later than a specified date. e.g. =If(today>=date,calculated value,""). How do I do that? As I stated it here it doesn't work"
The answer was
"=IF(TODAY()>=A1,calculated_value,"")
After this how do i go ahead i want to take the time in A1 then when this time arrives it should automatically show the amount in column P1
You would use the formula in P1
ie- in P1
=IF(TODAY()>A1,"Today is after "&TEXT(A1,"ddmmyyy"),"")
Hope this helps
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
trouble would be to get time you need =now() but now only updates when sheet recalculates
so entering =now() and its 17/03/2013 19:20
it will stay like that until a recalculation occurs.so for something to change when a certain time is reached you will need vba code to do it
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thanks,
its what i needed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks