Solved how do I get the following formula to work in an IF statemen

September 28, 2016 at 16:12:03
Specs: Windows 64
=IF(F2="Yes","TODAY()-P2","Nil")

its the "TODAY()-P2", that I can not get to work
the formula will not calculate


See More: how do I get the following formula to work in an IF statemen

Reply ↓  Report •


#1
September 28, 2016 at 19:15:15
✔ Best Answer
The quotes tell Excel that whatever is between them is a text string.

Remove the quotes around that argument and see what happens.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Reply ↓  Report •
Related Solutions


Ask Question