Complicated Formula

R

Renegade

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
 
J

Jacob Skaria

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

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

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top