multiply by absolute #

[muizac]

Hi,

Can you pelase tell me how I can mutliply by absolute numbers?


Avg $ per customer, Forecast customers, Rev,
100, 1.75, 200 (not 175),
100 , 0.9, 100 (not 90),

Thanks,

Andrew

 

[jindon]

=Ceiling(A1*B1,100)
?

 

[Greg Truby]

If Jindon guess correctly then you can simply ignore this. Otherwise:

• There really are no such things as ABSOLUTE numbers. There are absolute values which are the positive value of any number (or distance from zero, if you prefer).
• Do you mean ABSOLUTE VALUES or do you mean INTEGERS?
• Does your sample include only inputs and not desired results? I hope so, otherwise please provide more information.

 

[zzjasonzz]

what about

=ROUND(B1,0)*A1