If operations again

=IF(AND(B13=3,F13=480 / 277),3,IF(AND(B13=2,F13=480 / 277),2))

why does this not work for some reason as soon as I put / it will not out put for me all I recieve is #### any suggestions.

Thanks in advance.

Hi

Can you explain what you are trying to acheive and we will try and help

nika

What I am trying to achieve is this:

In cell B3 I enter either 1,2,3

Now depending on what is in cell F13, I want the output to be in H13.

It has to do with electrical panels for commercial buildings

In B3 if I enter

1 and F13 is 480 output 2

2 and F13 is 480 output 2

3 and F13 is 480 out put 3

1 and F13 is 480 / 277 output 2

2 and F13 is 480 / 277 output 3

3 and F13 is 480 / 277 out put 4

The reason for the space in 480 / 277 is so that way the cell will not divide it.

Another question is it I input a number (say 100) and want to output a number (8) but I want to have 18 possible outputs what is the best way to accomplish this since the “if” command can only have seven operations per cell? Would a look up work?

Thanks for the help.

Hi again

Would this help

=IF(AND(B13<3,F13=480),2,IF(AND(B13=3,F13=480),3,IF(AND(B13=1,F13="480 / 277"),2,IF(AND(B13=2,F13="480 / 277"),3,IF(AND(B13=3,F13="480 / 277"),4,"input error")))))

for your other question VLOOKUP would work well with what you require