Excel 2007 : Multiplying in an IF statment.

[khemikal]

Hello again.

First off i want to thank everyone that is posting great answers. there is a lot of great help here and it is very much appriciated.

So, here's my problem. I'm trying to set my N1:N500 to do a spicific task. here is what i have:
=IF((B69=" Ale"),G69*.1,IF((B69="Can Dark"),G69*.1,IF((B69="Can Premium "),G69*.1,IF((B69="Can Light"),G69*.1,IF((B69="Bottle Ale"),G69*.2,""))

the parts in red are what i can't get to work. if i put a number in there instead of a formula then it works great, but its not working like this.

Any Help would be greatly appriciated.

thank you in advance!

[sweep]

Hi,

Try this:

=IF(B69="Ale",G69*0.1,IF(B69="Can Dark",G69*0.1,IF(B69="Can Premium",G69*0.1,IF(B69="Can Light",G69*0.1,IF(B69="Bottle Ale",G69*0.2,"")))))

careful where you use brackets, and spaces!

[khemikal]

Hi,

Try this:

=IF(B69="Ale",G69*0.1,IF(B69="Can Dark",G69*0.1,IF(B69="Can Premium",G69*0.1,IF(B69="Can Light",G69*0.1,IF(B69="Bottle Ale",G69*0.2,"")))))

careful where you use brackets, and spaces!

Thank you SOOOO MUCH!!

Works PERFECT!!!!