|
You must be a logged in user to report a bad post!
| Posted By |
Message |
JenMarie
One day at a time
Member since 11/07 7397 total posts
Name:
Jennifer
|
Excel Help
If I want to use a logic formula to say if a date (any date - it will never be the same) is in X cell, enter 15 in Y cell. Does anyone know how to write that formula? I was thinking I could just do one that says if there is any value in the cell, enter 15, but if there is no value (cell is empty) nothing is entered.
|
Posted 1/30/08 10:26 AM  |
| |
|
Long Island Weddings
Long Island's Largest Bridal Resource |
HeathKernandez
Our Ron is an awesome Ron
Member since 4/07 9091 total posts
Name:
baby fish mouth
|
Re: Excel Help
I *think*
format the cells to date... and then use this formula: =SUM(A1+15)
|
| Posted 1/30/08 10:29 AM |
| |
|
JenMarie
One day at a time
Member since 11/07 7397 total posts
Name:
Jennifer
|
Re: Excel Help
Posted by carolinep24
I *think*
format the cells to date... and then use this formula: =SUM(A1+15)
Thanks, but that's not going to do what I want. I need to have a value entered in one cell if there is anything in another.
|
| Posted 1/30/08 11:27 AM |
| |
|
Potentially Related Topics:
Currently 147044 users on the LIFamilies.com Chat
|
