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

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
 
S

Sandy Mann

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

[email protected]
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
 
B

Boon

Put in Column I1
=IF(AND(G1>=200,H1>=50),50,0)
copy and paste in cells all the way down
 
Top