How Can I correct the below formula? I want to round up or down based on 15 and then to the closest 100.
The formula I have so far is:
=IF (RIGHT ((P2*3.294),5) >15,ROUNDUP (P2*3.294,-2),ROUNDDOWN (P2*3.294,-2))-0.01.
I believe it is not working because RIGHT is returns as a character and not a numerical value. How can i get this to work?
Bookmarks