MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Cell filling formula

Posted by KC on January 31, 2002 12:20 PM

First off thank you for any help you can give me with this problem. I am working on a spreadsheet for my boss. What I need is to figure out how to word the formula to enter a dollar amount in one cell if the date in a cell on the same row in another colum has been filled.

Thanks again.


Posted by anno on January 31, 2002 1:13 PM

hi kc
assuming the dollar amount is 2 and is to go in A1 and the date is in B1, the simplest way is to in A1 put =IF(B1,2)with A1 formatted as currency. however it's probably better to have the formula refer to a dollar value in another cell rather than in the formula. so, with the dollar value in C1, the formula in A1 becomes =IF(B1,C1). the only thing now is that the formula won't care what is actually in cell B1 ie. it's looking for any value and will return a result whether what's in B1 is a date or not. if that's a problem you may want to look at data validation. the excel help topic on this is very easy to follow.
hope this is what you want.