correct formula

  • Thread starter Thread starter Eamon
  • Start date Start date
E

Eamon

Hi,

In columns B to H i have sales figures, i want to get the average sales
rounded to the nearest whole integer...

In cell I 2 i have entered the following formula
=ROUND(AVERAGE(B2:H2),0)

Can someone please confirm if this is the correct formula or any suggestion
will be much appreciated.

Regards,

Eamon
 
Frank,

Thank you

Another problem

In column A i have the names of products, if the sales were over 5000 the
salesperson will receive a bonus of 2%, >10000 a bonus of 3%, >15000 a bonus
of 4%
using the following formula i can return the figures to the bonus column...
=IF(B2>5000,B2*2%,IF(B2>10000,B2*3%,IF(B2>15000,B2*4%,0)))

But if i only wanted to give the above bonus for a specific product i.e.
"Sony" how would i amend the formula?

Eamon
 
Hi,
I have come up with the following...

=IF(A2="Sony",IF(B2>5000,B2*2%,IF(B2>10000,B2*3%,IF(B2>15000,B2*4%,0))),0)

is there a better way?

Eamon
 
Back
Top