Forum Discussion
Multiple formulas within formula
I have not used the table before. This could work.
Unfortunately the formulas are not my forte as I am a novice.
We currently use this formula:
=ROUNDUP((((A1*1.09)*1.1)*1.1)*1.75,0)
This is what I would need to translate into the table so the 1.75 is changeable specifically.
Any thoughts would be much appreciated.
Thank you
THAT formula is totally different from what you showed before. Totally different.
So although it can still be done via a table, why don't you go back to the layout you showed at the start and make your expectation more complete. Are you now saying you want something like this?
if the cell A1 has a price of :
less than 89, I need the formula to be =ROUNDUP((((A1*1.09)*1.1)*1.1)*1.75,0)
less than 150, I need the formula to be =ROUNDUP((((A1*1.09)*1.1)*1.1)*1.65,0)
less than 230, I need the formula to be =ROUNDUP((((A1*1.09)*1.1)*1.1)*1.56,0)
greater than 230, I need the formula to be =ROUNDUP((((A1*1.09)*1.1)*1.1)*1.42,0)
That series of MULTIPLICATIONS ends up producing prices (assuming that's what they are) that are VERY different from the first formula you requested, where you only multiplied once (by 1.1) and then ADDED the final figure.
I see that you said you're a novice, and that's fine; we all began as novices. But if you mean just to ADD, then you should be using the plus sign; if to multiply, then the asterisk.
It also helps to set thoughts of Excel formulas aside and just describe clearly in words with some basic arithmetic what you are wanting to accomplish.
