View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Is this right please.

If you want to round to the nearest whole number then yes it is

Mike

"Steved" wrote:

Hello from Steved

The objective is how many complaints per 100,000 passengers

949,343 passengers in Cell G35
52 complaints in Cell G43
The formula is =G43*100000/G35 in Cell G45 giving me a total off
5 complaints per 100000 passengers

Thankyou.