I know this is probly very basic I cannot seem to figure it out. This formula I have found is rounding the dollar to the neartest $0.99 I dont want it to round I just want the exact number. can someone help me with removing the rounding?
=ROUND(A1 * LOOKUP(A1,{0,5,10},{1.4,1.3,1.2}), 0) - 0.01
Bookmarks