Thread: Calculation
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Calculation

It would be easier if you use a formula to do this.

B47 = some number

Enter this formula in say, C47:

=IF(ISNUMBER(B47),B47*7.15,0)

--
Biff
Microsoft Excel MVP


"Chey" wrote in message
...
This is going to be a locked form. Many users are going to use it. It
would
be easier if they could just type in a number amount. This represents
hours
worked. Our min wage is 7.15 an hour.

Thanks

"Wigi" wrote:

Hi Chey

Then first, move your cursor to that cell.

Start typing:

=160*7.15

and once you've done that, hit the Enter key.

Are you succeeding?

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Chey" wrote:

In cell B47 I want to type in a number example 160 and it multiply by
7.15
and give the answer. Can someone assit me in how to do this.

Thanks
Chey