#1
|
|||
|
|||
Can I pre-populate cells with a formula?
Hi. Is it possible to input a formula into selected cells such that, upon entering a number, the cell will display the final answer? Thanks. |
#2
|
||||
|
||||
Since that's how formulae work anyway, I don't see what the issue is. Of course, you might want to add some logic to prevent error displays and/or 0s when data are missing, but that's not really an issue of whether you can have a formula, so much as an issue of what it needs to contain.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula works on most cells | gbaker | Excel | 1 | 04-26-2014 12:31 AM |
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 | bobznkazoo | Excel | 2 | 03-27-2014 11:14 AM |
Copying a formula that uses pivottable cells | Paul46 | Excel | 0 | 02-08-2014 07:04 AM |
Excel Formula - Conditional replacement of cells | mag | Excel | 0 | 10-27-2012 08:30 PM |
Populate cells in Word from a database | hotlilshan | Word | 3 | 12-09-2008 01:51 PM |