Complicated Formula
 

I have Excel XP, and I am in need of a formula that will calculate the
following: Example: =countif(G3:L3,"A") . . . once it determines the count
of how many As, it will then need to determine, if that count is greater than
or equal to a number (let's say 3), then, if it is =or 3, it will place in
the cell an amount of $12,000 as a cap).

If anyone has a clue as to how I can even come close to getting a formula
that will do all of this, I will be forever indebted.

Thanks in advance for your time and assistance.

Renegade

Complicated Formula
 

Try
=IF(COUNTIF(G3:L3,"A")=3,12000,"")

'OR
=IF(COUNTIF(G3:L3,"A")=3,12000,"Do something")

If this post helps click Yes
---------------
Jacob Skaria


"Renegade" wrote:

I have Excel XP, and I am in need of a formula that will calculate the
following: Example: =countif(G3:L3,"A") . . . once it determines the count
of how many As, it will then need to determine, if that count is greater than
or equal to a number (let's say 3), then, if it is =or 3, it will place in
the cell an amount of $12,000 as a cap).

If anyone has a clue as to how I can even come close to getting a formula
that will do all of this, I will be forever indebted.

Thanks in advance for your time and assistance.

Renegade