Good Day,
I am having some difficulty figuring out my formula.
This obviously works just fine:
=IF('Inventory Sheet'!B54<0, "OVERSTOCK", 'Inventory Sheet'!B54)
I then added MROUND. It works when the number being referenced is positive only. When there is a negative number, it does not work.
=MROUND(IF('Inventory Sheet'!B54<0, "OVERSTOCK", 'Inventory Sheet'!B54),12)
Here is the original formula on the 'inventory sheet' I am referencing:
=IF(D54>C54,E54-(D54-(C54*0.25)),(E54-D54)+(C54*0.25))
Here is the info you can use for each.
C54 = 24
D54 = 42
E54 = 18
It works however, if you put the numbers like this:
C54 = 24
D54 = 18
E54 = 42
I essentially want the number to round to the nearest 12 when it is positive, and if negative, state 'OVERSTOCK'.
Any help is appreciated!
Bookmarks