If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how can i mulitply without having a figure yet?
Hi
I want to have a few cells timed by two but haven't got the figures yet of what i'm times-ing. is there a way to format the cell to automatically times when a number is added into it? Thanks |
#2
|
|||
|
|||
how can i mulitply without having a figure yet?
Think you could set-up something like this
Assuming the data (the figures) will be entered in A2 down Put in B2: =IF(A2="","",A2*2) Copy B2 down as far as data is expected in col A, eg down to B100. Col B will auto-return the required results. You can point to/use col B for further downstream calcs. -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:370 Subscribers:68 xdemechanik --- "sonia" wrote: I want to have a few cells timed by two but haven't got the figures yet of what i'm times-ing. is there a way to format the cell to automatically times when a number is added into it? Thanks |
Thread Tools | |
Display Modes | |
|
|