IF-THEN Formula help needed
That did it. Thank you for your help!!!
"RagDyeR" wrote:
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?
|