SOLVED

New Contributor

# looking to make a specific formula

Hello

I'm looking to create a specific formula in excel.

Example

\$50 less 50% less 8% multiply by 50% and round up or down to the nearest \$0.09

Dom

4 Replies

# Re: looking to make a specific formula

=MROUND(F6*(100%-50%)*(100%-8%)*50%,0.09)

I suspect it may not do what you want. If so, please explain more clearly what you expect the result to be.

# Re: looking to make a specific formula

Hi Hans
You are correct it did not work, Thank you for your effort on this.
The goal is to calculate item cost and selling price from a list price ( then round up or down to the nearest 0.99

Here is the equation I use on the calculator.

50x0.5=25x0.92=23x1.5=34.50 (then round up to 34.99)
or
50x0.5=25x0.92=23x1.49=34.27 (then round down to 33.99)
hopefully this makes it clearer and thanks again

# Re: looking to make a specific formula

That is quite different from what you asked in your first post in this discussion...

=ROUND(F6*(100%-50%)*(100%-8%)*(100%+50%),0)-0.01

best response confirmed by Domenic_tbh (New Contributor)
Solution

# Re: looking to make a specific formula

Bravo

works perfect.

thank you so much for your help Hans