I have created a spreadsheet that utilizes a drop down list. What I am looking to do is when "BRK" or "BRK*2" is used, the final answer will be rounded to the next tens.
This is the formula I am using. Where should the ROUND be included?
=IF(A8="BRK",G8*0.25,IF(A8="BRK x2",G8*0.25*2,IF(A8="SLD",G8*1,IF(A8="SLD x2",G8*2,IF(A8="DBL",G8*2,IF(A8="DBL x2",G8*4,IF(A8="@40",G8/40,IF(A8="@80",G8/80,IF(A8="@80 x2",G8/80*2,IF(A8="@40 x2",G8/40*2))))))))))
When "BRK" or "BRK*2" I get an answer of 1687. I need that total to be rounded to 1690.
Thanks,
Bookmarks