Try this:

=(COUNTIF(AT5:AT34,G5/F6)0)*(E6*G3)

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Brandty123" wrote in message
...
I am having trouble finding an IF-THEN formula that works for my scenario.
My
$AT5:$AT$34 are numbers 1-30 and trying a list in the IF-THEN formula did
not
work. I also tried entering each number separately 1, 2, 3, 4, 5 etc... but
that did not work (too many IF-THEN statements). Below is my formula:

=IF(G5/$F$6=$AT$5:$AT$34,$E$6*G3,0)

Essentially if G5/$F$6 returns a whole number or integer (without decimels),
then I want the calculation of $E$6*G3 to happen.

Does anyone know how to make the IF-THEN statement work with a list in a
single row or column, or have a better idea?