Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW TO 'BLINK' A FIGURE INSTEAD OFF BOLDING THE FIGURE | Excel Worksheet Functions | |||
Can't figure out | Excel Worksheet Functions | |||
Can't figure it out . . . | Excel Worksheet Functions | |||
Max figure help | Excel Discussion (Misc queries) | |||
Find all cells with a number and mulitply | Excel Discussion (Misc queries) |