Forum Discussion
Solved
If Statement returns NOW() Function
I need the formula that will allow me to say If Cell X isnot blank then return now() for true or "Not Checked out" for false. =IF(B2 <> "","Date","Not Checked Out") I can't figure out how to...
Hi Jennifer,
Simply, replace this:
=IF(B2 <> "","Date","Not Checked Out")
With this:
=IF(B2 <> "",NOW(),"Not Checked Out")
Or this:
=IF(B2 <> "",TODAY(),"Not Checked Out")
Hi Jennifer,
Simply, replace this:
=IF(B2 <> "","Date","Not Checked Out")
With this:
=IF(B2 <> "",NOW(),"Not Checked Out")
Or this:
=IF(B2 <> "",TODAY(),"Not Checked Out")
Awesome, thanks so much.