sjsandborn
New member
- Joined
- Jul 16, 2015
- Messages
- 2
- Reaction score
- 0
- Points
- 0
I'm hoping someone can help me. I cannot for the life of me get my formula to work. I, essentially, am trying to do the following "if cell X = No, do this, if cell value equals yes (or no is false), do this. the formula I'm currently trying is below.
=IF(F65,"No",((IF(C77<2000000,J65,(IF(AND(C77>=2000000,C77<10000000),J66),(IF(AND(C77>=10000000,C77<25000000),J67,(IF(C77<=25000000,J68,"error"))),(IF(C77<1000000,J65,(IF(AND(C77>=1000000,C77<5000000),J66,(IF(AND(C77>=5000000,C77<10000000),J67,(IF(C77<=1000000,J68,"error")))))))))))))
what I'm trying to do is:
If cell F65 =No = If(C77<2000000,J65,(IF(AND(C77>=2000000,C77<10000000),J66),(IF(AND(C77>=10000000,C77<25000000),J67,(IF(C77<=25000000,J68,"error")
If Cell F65 = yes = IF(C77<1000000,J65,(IF(AND(C77>=1000000,C77<5000000),J66,(IF(AND(C77>=5000000,C77<10000000),J67,(IF(C77<=1000000,J68,"error")
=IF(F65,"No",((IF(C77<2000000,J65,(IF(AND(C77>=2000000,C77<10000000),J66),(IF(AND(C77>=10000000,C77<25000000),J67,(IF(C77<=25000000,J68,"error"))),(IF(C77<1000000,J65,(IF(AND(C77>=1000000,C77<5000000),J66,(IF(AND(C77>=5000000,C77<10000000),J67,(IF(C77<=1000000,J68,"error")))))))))))))
what I'm trying to do is:
If cell F65 =No = If(C77<2000000,J65,(IF(AND(C77>=2000000,C77<10000000),J66),(IF(AND(C77>=10000000,C77<25000000),J67,(IF(C77<=25000000,J68,"error")
If Cell F65 = yes = IF(C77<1000000,J65,(IF(AND(C77>=1000000,C77<5000000),J66,(IF(AND(C77>=5000000,C77<10000000),J67,(IF(C77<=1000000,J68,"error")