# MROUND & IF Formula Challenges

1. ## MROUND & IF Formula Challenges

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!

2. ## Re: MROUND & IF Formula Challenges

you cant round text so it should be
=IF('inventory sheet'!B54<0, "OVERSTOCK",MROUND( 'inventory sheet'!B54,12))

3. ## Re: MROUND & IF Formula Challenges

Try this...

=IF('Inventory Sheet'!B54<0, "OVERSTOCK", MROUND('Inventory Sheet'!B54,12))

4. ## Re: MROUND & IF Formula Challenges

Amazing, thanks. Can't believe I gaped on that.

Cheers,

There are currently 1 users browsing this thread. (0 members and 1 guests)