LinkBack URL
About LinkBacks
I want to calculate the selling price of a product with the profit of 300%.
When I'm dial these settings;
Set Cell = E6
To Value = 300
By Changing Cell = H2
I get this error "Formula In Cell Must Result In A Number"
Why? How can I fix it?
I want to calculate the selling price of a product with the profit of 300%.
When I'm dial these settings;
Set Cell = E6
To Value = 300
By Changing Cell = H2
I get this error "Formula In Cell Must Result In A Number"
Why? How can I fix it?
Type 1 into H2 before you start.
I ran it several times.
The max profit is 62%
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
You can calculate selling price with
=(B2+B4)/(100*(1-B3/100-B5/100)-B6)
As mehmetcik wrote, max profit is 62%, otherwise denominator will become negative.
HTH,
Francesco
Aim high or don't even try.
---------------------------------
If your question has been answered, don't forget to mark the thread as SOLVED.
If you find an answer helpful, click on the star icon at the bottom of the post.
Thank you very much for the answers.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks