More help please... I'm stupid !!!

  • Thread starter Thread starter Hastey
  • Start date Start date
H

Hastey

I really appreciate the help you guys give.... it's enabling me to
speed up a lot of my calculations.

Here we go with the next problem:

I have the following columns:

Column G - Staff ATV (Average Transaction Value)
Golumn H - Number of Deals
Column I - Bonus Payment

What formula do I put in Column I, if I'm saying that the member of
staff will receive a £50 bonus when their ATV exceeds £200, but they
must have a minimum number of 500 deals.

Many thanks

Darren
 
Try:

=(G2>=200)*(H2>499)*50

or:

=IF(AND(G2>=200,H2>=500),50,0)

or if you want a black looking cell:

=IF(AND(G2>=200,H2>=500),50,"")

But that may mess up any calculating that use that cell

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk


I really appreciate the help you guys give.... it's enabling me to
speed up a lot of my calculations.

Here we go with the next problem:

I have the following columns:

Column G - Staff ATV (Average Transaction Value)
Golumn H - Number of Deals
Column I - Bonus Payment

What formula do I put in Column I, if I'm saying that the member of
staff will receive a £50 bonus when their ATV exceeds £200, but they
must have a minimum number of 500 deals.

Many thanks

Darren
 
Back
Top