Need some formula advice for two part problem

  • Thread starter Thread starter BENJAMIN GOODBRED
  • Start date Start date
B

BENJAMIN GOODBRED

I hope someone can help me out with this problem ?

I want to place a date in a block when another block reads 100%.
say block B4 reads 100%, I want to place a date in D4 to represent when
(Days360) that block (B4) reached 100%.

Hope someone can help, thanks.

Mr. Goodbred
 
Benjamin Goodbred,
I came up with this solution:
Format cell B4 as percent, D4 as Date 3/14/01.
In cell D4 type formula:
"=IF(B4=100%,NOW(),"")" do not add the first " or the last "
The cell D4 will remain empty("") until B4 is equal to 100%.
hth
 
Back
Top