Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hello my name is ***** ***** I'd be happy to assist you with this. Can you attach the spreadsheet to this message and tell me what cells you are trying to formulate?
I'll take a look now.
They actually do seem to be working. For some reason it just so happens that those results come out to the same. When I calculate just the numbers that the formulas represent, I come up with the same results as the formulas in the cells.
I don't know how you managed to make that happen but it's quite interesting.
Also if you change any of the numbers in the referenced cells the result changes.
Are you seeing the same thing I'm seeing?
I don't know if you can see what I'm talking about but if not I can show you what I mean.
for example, the formula in N24 reads =M24/R$129^O24
M24 = 35970.44
R129 = 1.00625
O24 = 8
if you calculate 35970.44/1.00625^8
the result will be 34221.47 which is the same thing the formula is giving.
You change any of those numbers in the formula, even just a decimal number, and the result will change.
So it appears that the formulas are working.
I said if you change any of those numbers in the formula but I meant in the example above.
Are you there?
Yes I understand and I had to really look at it hard for the same reason. Had me going too!
Please remember to rate my time and help before you go by clicking the STARS or accept button so that I may receive credit for helping you.