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)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment