S
Shawn
I have 3 numbers, 3.49,5.49 and 9.79 in a spreadsheet. When a cell (J2 in
this case) displays 3.49 I would like my formula cell to use 2.26, however if
it is 5.49 I would like it to use 5.05. So far I have
=(IF(J2=3.49,2.26,5.05)+(I2*0.85)) I should mention that I2 is a sales price
minus 15% added to the result of J2. This works great except I need to
calculate for 9.79 to return 8.95 and use that in my calculation. Any ideas,
help would be greatly appreciated.
this case) displays 3.49 I would like my formula cell to use 2.26, however if
it is 5.49 I would like it to use 5.05. So far I have
=(IF(J2=3.49,2.26,5.05)+(I2*0.85)) I should mention that I2 is a sales price
minus 15% added to the result of J2. This works great except I need to
calculate for 9.79 to return 8.95 and use that in my calculation. Any ideas,
help would be greatly appreciated.