SOLVED

looking to make a specific formula

New Contributor

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

thank you in advance for your help

Dom

4 Replies

@Domenic_tbh 

=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.

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

@Domenic_tbh 

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

@Hans Vogelaar 

Bravo

works perfect.

thank you so much for your help Hans