Mikeyis4dcats
Technical User
Can anyone point me to the error in this formula?? I'm going crosseyed!
=((IF($C$4<=500),23.50,(IF($C$4<=2000)),((($C$4-500)/100)*3.05),IF($C$4<=25,000),((($C$4-2000)/1000)*14),IF($C$4<=50000),((($C$4-25000)/1000)*10.10),IF($C$4<=100000),((($C$4-50000)/1000)*7),IF($C$4<=500000),((($C$4-100000)/1000)*5.6),IF($C$4<=1000000),((($C$4-500000)/1000)*4.75),((($C$4-1000000)/1000)*3.65))
=((IF($C$4<=500),23.50,(IF($C$4<=2000)),((($C$4-500)/100)*3.05),IF($C$4<=25,000),((($C$4-2000)/1000)*14),IF($C$4<=50000),((($C$4-25000)/1000)*10.10),IF($C$4<=100000),((($C$4-50000)/1000)*7),IF($C$4<=500000),((($C$4-100000)/1000)*5.6),IF($C$4<=1000000),((($C$4-500000)/1000)*4.75),((($C$4-1000000)/1000)*3.65))