problems with "if function

[Suz]

=IF(F7>=1,K7/7,IF(F7=0,K7/6,IF(I7>=1,K7/7,IF(I7=0,K7/6,IF
(F7&I7>=1,K7/8,IF(F7&I7=0,K7/6,K7/8))))))
First to If's work properly. The rest of the formula is
just not. I know I am missing some things, I just can not
figure it out. Any help would be great! The goal is to
have the cell F7 and I7 work the same separately and if
both are in use I need them to work together such as K7
needs to be divided by 8 instead of when used single they
divide by 7 and when neither is used I need k7 to be
divided by 6. I hope this make sense. Again, any help
would be apprectiated.

 

[Maxwell]

=IF(and(F7>=1,I7=1),K7/7,IF(and(F7=0,I7=0),K7/6,K7/8))

 

[mudraker]

Suz


unless f7 contains text your if statement is always going to match on
F7>=1 or F7=0

meaning the rest of the statement is irelevant

The same rules would also apply for testing I7 assuming it got passe
testing f7

Testing of both f7 & i7 together would also give the same resul

 

[Suz]

I'll try this. Thanks!

-----Original Message-----
=IF(and(F7>=1,I7=1),K7/7,IF(and(F7=0,I7=0),K7/6,K7/8))



.