Techy Help: Excel IF Statments - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Techy Help: Excel IF Statments

Disco Avatar
7y, 10m agoPosted 7 years, 10 months ago
My current if statment reads

=IF(a1=P, then "PAID")

Is there anyway i can get PAID to read "todays date")

ie: not the words todays date, but the acutal date
Disco Avatar
7y, 10m agoPosted 7 years, 10 months ago
Options

All Comments

(10) Jump to unreadPost a comment
Comments/page:
#1
ahh, i think there is a button in excel to input date. Go to Options and properties and see if you can change it.
#2
Hi todays date in excel is a formula =now() put this in it's own cell, then point the formula to it,

so cell a2 reads =now()

=IF(A1="p",a2) then format the cell to read the date,
banned#3
date()
#4
Unfortunately, now() will report the current time continuously - so if you open a document with that in it in two days time the now() function will report that time and date, not the original time and date. That might be a problem?
#5
Ooops, Ignore!
#6
How about keeping that if statement but then create a macro which searches for "PAID" and then changes it to that days date on exit???
#7
A VB script like this may work,

"Function StaticDate()
' Returns the current date but does not change on recalculation
StaticDate = Now
End Funtion "

More info on here...

http://www.ozgrid.com/forum/showthread.php?t=46414
banned#8
today() reports the date.

So if you change the formula to: =IF(a1=P, today(),0) OR as one of the previous posters says.

=if(a1=p,a1,0) then in a1 (or any cell) put =today()
#9
percywan
today() reports the date.

So if you change the formula to: =IF(a1=P, today(),0) OR as one of the previous posters says.

=if(a1=p,a1,0) then in a1 (or any cell) put =today()


But ='today' recalculates everytime you open the workbook...
banned#10
Oh yeah. thats slightly more complicated and they could sort if by writing some vba which would run upon the opening of the workbook to put the date in if it was paid.

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!