I hope you can understand what I am trying to do here. I have a chart, and a value that I came up with a different formula. I know want to take that value in B16 and compare it to the chart and depending where it falls, then go over and do the math for the line that corresonds to the value of B16. This formula below is as close as I can get, but it does not work. Any help would be greatly appreciated.
=If(B16>=(F18)and<=(G18),round((round((B16-J18)*I18,2)+H18)/26,2),IF(B16>=(F19)and<=(G19),round((round((B16-J19)*I19,2)+H19)/26,2),IF(B16>=(F20)and<=(G20),round((round((B16-J20)*I20,2)+H20)/26,2),IF(B16>=(F21)and<=(G21),round((round((B16-J21)*I21,2)+H21)/26,2),IF(B16>=(F22)and<=(G22),round((round((B16-J22)*I22,2)+H22)/26,2),IF(B16>=(F23)and<=(G23),round((round((B16-J23)*I23,2)+H23)/26,2),IF(B16>=(F24),round((round((B16-J24)*I24,2)+H24)/26,2))
2007-02-16
05:42:32
·
5 answers
·
asked by
DragonGirl87
2