Nested IFs:Greater, Same, or Less.

[Chardon]

Hey all, im new to these Excel forums and everyone looks pretty cool here, but i have a question. I have been stuck on this question for a couple days, i would like to solve it on my own, but its driving me insane and i just want an answer. This is the question.
Use a function to compute the totals in row 7. In a row 8, compare that month's total expenses with the prior month's and display the word Greater, Same, or Less. Since february's total expense is less than January's, display Less in C8. Since January is the first month, there is no comparison with a prior month. Use nested IF fucntion. And this is what the final outcome should look like. \1
You are thinking , you have the answer-- right? I need to enter the right formula for it too pass through the grading system on the computer.

I have tried this formula to no avail.

Please Login or Register  to view this content.

[mewingkitty]

Bad example. Yours shows a comparison with the following month, yet your statement says you want a comparison with the prior.

Please Login or Register  to view this content.

That's your solution for prior month.

[Chardon]

It is still giving me an error saying the Function/Formula is not correct.

[mewingkitty]

Where are you putting it?

[Chardon]

In C8 in February under $522.00

[mewingkitty]

You mean like in the attached workbook...

[Chardon]

This is the error im getting. And yea i think like that.

[mewingkitty]

You lost me there...
So it works, like in the workbook that I posted, but... it doesn't work...

mew?

[Chardon]

I don't get what you mean by the workbook you posted. Your formula works, but when i go to put it in the grading system i get that error saying the function/formula is wrong.

[teylyn]

mew, I think there's a reason why we don't do homework

[mewingkitty]

I see.

mew...