Thread: odd if statement help?

Hello everyone,

I am trying to help a friend make an excel table that does a few different things.. so far there has been no problems until right now...

Basically he wants to input dates, and some numbers about some information. Based on those 2 numbers it will return the sum. Then calculate a percentage based on those numbers, then get a ratio based of the percentage numbers. From their it does a true false test to see if that number is greater than 4. All this works just fine and was no trouble.

The problem is now he wants this "Final Test" to first check if we get a True (from if greater than 4) AND if the ratio for today is greater than yesterday then return UP. If the test is True, but ratio is less than the previous day return DOWN. If it was False to begin with return -.

I tried to do a few different nested if functions, which none worked, and I also tried to create a user defined function to do the tests.. this also is not working. Does anyone have an Idea or know how to get excel to handle this?

Thank you for any and all help.