Forum Discussion
Ratio Formula Help!
Hello and thank you in advance for any help! I am working on a spreadsheet someone created that has the below formula: =AA4*4.5-Z4 Actual numbers= 10*4.5-34 This formula is being used to...
You probably won't get an answer because your question is not clear.
Please note that Excel takes into account the dot before dash calculation. So when you write:
=10*4.5-34
the same as:
=(10*4.5)-34
is
=45-34 = 11In your second example, this is what comes out:
=10*2-34
is
=20-34 = -14The note: "This formula is being used to show how many it will take to get to 4.5" is not comprehensible to me. Please explain exactly what your formula is supposed to calculate.