Thursday, December 8, 2011

Microsoft Excel - IF statement using actual date.?

i have a spreadsheet full of payment information. i want to create an IF that states when it gets to the first of December pay will increase 2.5% but i need it too read the computers date,











HOW?!?!?!?|||Well, if you are trying to read the computer's date, you could use the TODAY() function. That gives the current date and time.





So an if statement might go something like...





=IF(TODAY()%26gt;"12/1/2008",12.50, 10.00)





... where if it's true, the value for the field is 12.50, if it's false, the value is 10.00. Fill in the values you need there.|||If the above doesn't work, try this (assuming you have current pay rate in Col A starting at row 2):


this goes in B2:





=if(today()%26gt;=date(2008,12,1),A2*


1.025,A2)

No comments:

Post a Comment