how can i mulitply without having a figure yet?

[sonia]

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

 

[Max]

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

 

[Max]

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