| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula to change a value every 2 weeks
Hi there  I need a formula to make text in a cell change every 2 weeks. The text in the cell should read 'do not change air con. units', but every other week it should read 'change air con. units'. If you can help I would be very greatful. Thanks! -- Bobski ------------------------------------------------------------------------ Bobski's Profile: http://www.excelforum.com/member.php...o&userid=30358 View this thread: http://www.excelforum.com/showthread...hreadid=500147 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formula to change a value every 2 weeks
Maybe something like:
=IF(MOD(INT(A1/7),2)=1,"one week","other week") This starts the week on a Saturday. Bobski wrote: Hi there I need a formula to make text in a cell change every 2 weeks. The text in the cell should read 'do not change air con. units', but every other week it should read 'change air con. units'. If you can help I would be very greatful. Thanks! -- Bobski ------------------------------------------------------------------------ Bobski's Profile: http://www.excelforum.com/member.php...o&userid=30358 View this thread: http://www.excelforum.com/showthread...hreadid=500147 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formula to change a value every 2 weeks
Thankyou for your help Dave -- Bobski ------------------------------------------------------------------------ Bobski's Profile: http://www.excelforum.com/member.php...o&userid=30358 View this thread: http://www.excelforum.com/showthread...hreadid=500147 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| EDIT FORMULA BAR in excel 2003? why not? where is it? | Excel Worksheet Functions | |||
| Excel 97 - Adding Every 8th Row - Formula should work, but doesn't | Excel Worksheet Functions | |||
| How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions | |||
Linear Mode
