SwampthingX90
New Member
- Joined
- May 6, 2016
- Messages
- 22
So I have this formula below:
=IF(G6="",0,IF(I10="CIP",(IF(RIGHT(F6,1)<>"U",(0.75*G6+11),IF(G6<58,(0.624*G6)+10,(0.724*G6)+3))+IF(J10="CONV",IF(I10<>"CIP",IF(G6<=50,2^(G6/10),(1.2*G6-30)),0))+IF(MAX(L6:M6)<500,0,IF(MAX(L6:M6)>1000,G6*0.2059,G6*0.1071)))*0.3,IF(RIGHT(F6,1)<>"U",(0.75*G6+11),IF(G6<58,(0.624*G6)+10,(0.724*G6)+3))+IF(J10="CONV",IF(I10<>"CIP",IF(G6<=50,2^(G6/10),(1.2*G6-30)),0))+IF(MAX(L6:M6)<500,0,IF(MAX(L6:M6)>1000,G6*0.2059,G6*0.1071)))+(G6*0.2)+SUM(D10:D22)+SUM(H10:H22))
If G6 equals 43 i'm showing a formula result of 51.85; how is it coming up with that if everything else is left blank? Basically need a breakdown for this in layman's terms.
=IF(G6="",0,IF(I10="CIP",(IF(RIGHT(F6,1)<>"U",(0.75*G6+11),IF(G6<58,(0.624*G6)+10,(0.724*G6)+3))+IF(J10="CONV",IF(I10<>"CIP",IF(G6<=50,2^(G6/10),(1.2*G6-30)),0))+IF(MAX(L6:M6)<500,0,IF(MAX(L6:M6)>1000,G6*0.2059,G6*0.1071)))*0.3,IF(RIGHT(F6,1)<>"U",(0.75*G6+11),IF(G6<58,(0.624*G6)+10,(0.724*G6)+3))+IF(J10="CONV",IF(I10<>"CIP",IF(G6<=50,2^(G6/10),(1.2*G6-30)),0))+IF(MAX(L6:M6)<500,0,IF(MAX(L6:M6)>1000,G6*0.2059,G6*0.1071)))+(G6*0.2)+SUM(D10:D22)+SUM(H10:H22))
If G6 equals 43 i'm showing a formula result of 51.85; how is it coming up with that if everything else is left blank? Basically need a breakdown for this in layman's terms.
