Polanskiman
Board Regular
- Joined
- Nov 29, 2011
- Messages
- 119
- Office Version
- 365
- 2016
- 2011
- 2010
- 2007
- Platform
- Windows
- MacOS
- Mobile
Hello,
I need some help in simplifying 3 formulas. Here they are:
and
and
All these nested IF, AND, OR are driving me crazy. In principle they work as they should yet I can't help to think that there must be a way to simplify them.
I would have attached the worksheet where these 3 formulas are set into context (cell D24, F36 and I36) but it doesn't seem possible to attach files. I tried using the xl2bb Add-in but it doesn't seem to be working as expected. When I preview the post part of the selection made is clipped.
Any help would be appreciated.
I need some help in simplifying 3 formulas. Here they are:
=IF(C6<>"Tank Dimensions","",IF(OR(AND(C16="No",D23=""),AND(C16="No",D23<>""),AND(C16="Partially",D23=""),AND(C16="Yes 100%",D23<=""),AND(C16="partially",D19="")),"",IF(AND(C16="Yes 100%",D23=""),"",D13/(D11-($D$12/10))*((D11-($D$12/10))-(D23-($D$12/10))))))
and
=IF(AND(C16="yes 100%",D19<>"",D23<>""),D19-($D$12/10),IF(OR(C6<>"Tank Dimensions",C16="<please select>",AND(C6="tank dimensions",COUNTIF(D9:D12,"")),AND(C16="yes 100%",D23<>"")),0,IF(D19=0,0,D19-($D$12/10))))
and
=IF(AND(C6="tank dimensions",COUNTIF(D9:D12,"")),0,IF(AND(C16="yes 100%",D19<>""),(D19-($D$12/10)),IF(OR(C6="<please select>",C16="<please select>",C16="no",AND(C16="partially",D19=""),AND(C16="yes 100%",D23<>"")),0,IF(OR(D23=0,K36>0),0,(D23-($D$12/10))))))
All these nested IF, AND, OR are driving me crazy. In principle they work as they should yet I can't help to think that there must be a way to simplify them.
I would have attached the worksheet where these 3 formulas are set into context (cell D24, F36 and I36) but it doesn't seem possible to attach files. I tried using the xl2bb Add-in but it doesn't seem to be working as expected. When I preview the post part of the selection made is clipped.
Any help would be appreciated.