If then, If then, If then.....

[Jackie]

I can make the first "If" function work but when I want to add to it I keep
getting an error. Not sure which function I should be using?

If B6 = "1 x 4" then divide D6/12 then multiply times 0.17, If B6 = "2 x 2"
then divide D6/12 then multiply times 0.12, If B6 = "2 x 4" then divide D6/12
then multiply times 0.23, ........

I have 9 total to enter but I can narrow it down if I can only do 7 in one
strand.

 

[Khoshravan]

=IF(B6=2*2;D6/12*0.17;IF(B6=2*4;D6/12*0.23))
You should nest "if" like above inside previous If.
In Excel2003 the limitation of nesting is 7.

 

[Pete_UK]

If you have more than a few of these, it is better to set up a little
table somewhere (assume M1:N9) made up like this:

1 x 4 0.17
2 x 2 0.12
2 x 4 0.23

and so on for your other 6 values. Then you can just use this simple
formula instead of multiple IFs:

=VLOOKUP(B6,M$1:N$9,2,0)

If B6 is not exactly the same as the entries in column M (or blank),
this will return an error - you can avoid that by doing this:

=IF(ISERROR(VLOOKUP(B6,M$1:N$9,2,0))," wrong",VLOOKUP(B6,M$1:N$9,2,0))

Change the message to suit.

Hope this helps.

Pete

 

[Pete_UK]

I'm sorry, I didn't complete this. You want this formula:

=VLOOKUP(B6,M$1:N$9,2,0)*D6/12

or this one:

=IF(ISERROR(VLOOKUP(B6,M$1:N$9,2,0))," wrong",VLOOKUP(B6,M$1:N$9,2,0)
*D6/12)

Hope this helps.

Pete