Excel Help

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:

Topic Posted By Started Replies Forum
where can i download microsoft excel for free?? w/no viruses? raken40 10/24/05 3 Families Helping Families ™
Need help with Excel and Word - Mass Mailings Marcie 8/4/06 9 Families Helping Families ™
Excel file to pdf? KPtoys 5/1/06 13 Families Helping Families ™
Dumb excel question JenniferEver 4/23/06 3 Families Helping Families ™
Excel Question MsG 4/17/06 5 Families Helping Families ™
PowerPoint and Excel.. LBG30 10/18/05 6 Families Helping Families ™