Hello!
My current formula:
="Profit: "&ROUND((((((C6-(1/(((C3*2)+C2)/C3)))*10)*C3)*((C4/C5))))+((((C4-C5)/C4)*C2)*10),2)&" BB"
All I want is the above formula's answer multiplied by 10. Sounds simple, right?
When I put this in: ="Profit: "&ROUND((((((C6-(1/(((C3*2)+C2)/C3)))*10)*C3)*((C4/C5))))+((((C4-C5)/C4)*C2)*100),2)&" BB"
^the answer becomes x100 of what it was before, not x10?
Apologies if the way I have worded and/or explained this is poor!
Thank you to anyone who can help me, no doubt it is a simple fix.
Bookmarks