Results 1 to 2 of 2

Thread: Nesting If with And Functions Help Please

  1. #1

    Nesting If with And Functions Help Please



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi can any one help me nesting 3 formula with If and statements, I cant get passed #Value
    Click image for larger version. 

Name:	Example.jpg 
Views:	67 
Size:	75.0 KB 
ID:	1481

  2. #2

    Stumbled on the answer

    [QUOTE=pleased2help;8371]Hi can any one help me nesting 3 formula with If and statements, I cant get passed #Value
    Click image for larger version. 

Name:	Example.jpg 
Views:	67 
Size:	75.0 KB 
ID:	1481
    =IF(AND(A1=1,B1=1),C1*0.9,IF(AND(A1=2,B1=1),C1*0.9+2,IF(AND(A1=1,B1=2),C1*0.8,IF(AND(A1=2,B1=2),C1*0.8+2,IF(AND(A1=1,B1=3),C1*0.7,IF(AND(A1=2,B1=3),C1*0.7+2)))))) works for me

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •