looking to make a specific formula

[Domenic_tbh]

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

[#2]

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

[#3]

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

[#4]

@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

[#5 · Accepted solution]

@Hans Vogelaar 

Bravo

works perfect.

thank you so much for your help Hans