specifying cel contents range in embedded if Statement

trying to figure out how to specify a range in mt if statements.AG6 is my linked "control" cell for a combobox. cant seem to specify if it is i.e."2 OR 4". I just used the word "OR" in the code as an example of where i need to "OR" at.

Please Login or Register  to view this content.

Or here i cant specify a range like you normally do with a cell range using ":"
Here i am needing 2 through 4 or any size range for that matter.

Please Login or Register  to view this content.

any help would be greatly appreciated. thanx in advance

I'm probably missing something but will
IF(or(AG6=2,AG6=4),AA16*1.25,"")
do the trick?

yea, but i was hoping for a way to simplify it because im going thru like a ton of possible combinations between 2 cells. like a PHP Case: or switch: heres what i have to check all the possible combinations. need a simple way to do the same:

=IF(OR(AND(AG6=2,AG24=2),AND(AG6=2,AG24=4),AND(AG6=3,AG24=2),AND(AG6=3,AG24=4),AND(AG6=4,AG24=4),AND(AG6=4,AG24=2)),AA6*0.25,IF(OR(AND(AG6=2,AG24=3),AND(AG6=2,AG24=5)),AA6*1.25,IF(OR(AND(AG6=3,AG24=3),AND(AG6=3,AG24=5)),AA6*0.4,IF(OR(AND(AG6=4,AG24=3),AND(AG6=4,AG24=5)),AA6*0.75))))

Im a php, and python guy usually, so this is a lil new to me.

maybe

Please Login or Register  to view this content.

Hi fuston05
better test it first

Please Login or Register  to view this content.

your welcome & thanks for posting in the forum?

Dont forget to mark the post solved to help other searching for answers

Hi
Go the your very first thead and click "edit"
then click the "go advance" button
sroll up to the top combobox and select "SOLVED" and saved