# 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!  Register To Reply

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))  Register To Reply

3. ## Re: MROUND & IF Formula Challenges

Try this... =IF('Inventory Sheet'!B54<0, "OVERSTOCK", MROUND('Inventory Sheet'!B54,12))  Register To Reply

4. ## Re: MROUND & IF Formula Challenges

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

Cheers,  Register To Reply

##### Users Browsing this Thread

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

#### Tags for this Thread #### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1