Dear all,
IF(CR6<35&CR6>30,(AD6((AD6AE6)/5)*(CR630)),IF(CR6<40&CR6>35,(AE6((AE6AF6)/5)*(CR635)),IF(CR6<27&CR6>25.97,(AA6((AA6AC6)/1.03)*(CR625.97)),IF(CR6<30&CR6>27,(AC6((AC6AD6)/3)*(CR627))))))
I am unable to get desired results above second criteria
PLease help me out
IF(CR6<35&CR6>30,(AD6((AD6AE6)/5)*(CR630)),IF(CR6<40&CR6>35,(AE6((AE6AF6)/5)*(CR635)),IF(CR6<27&CR6>25.97,(AA6((AA6AC6)/1.03)*(CR625.97)),IF(CR6<30&CR6>27,(AC6((AC6AD6)/3)*(CR627))))))
I am unable to get desired results above second criteria
PLease help me out
Attachments

514.1 KB Views: 4