drop down boxes

A

andy

Hi everyone,
Ok i'll outline the situation. I am trying to produce an
invoice page on a system where the user can produce an
invoice etc, and I am wanting to make a cell show the
total cost for the accomodation. I have a drop down box
for the location name and for the cost per day, and the
number of days is shown in a separate cell. Is there a way
to show the total cost of the accomodation in this single
cell?
Help needed urgently!

Thanks, Andy.
 
O

Otto Moehrbach

Andy
I am not sure of what you want but from what you say, all you need is a
simple formula in that cell. Say the charge per day is in A1 and the number
of days is in B1. Then in the cell where you want the total cost of the
accommodation, put "=A1*B1" without the quotes. HTH Otto
 
Top