Basically, the spreadsheet has daily sales figures in column A, plus a running total of days worked in column B.
They're totalled up at the bottom of each column then divided with eachother for a daily average at the top of column C (C1).
What I need to do is get that total in column C to give me a number based on the value of that average.
So, for example;
If C1 is greater than 500, it should show "1"
If it's greater than 1000, it should show "2"
Greater than 1500 and it should show "3"
Greater than 2000, should show "4" and so on...
I just can't get it to work with multiples. "=IF(C1>500; 1)" works perfectly. As soon as I add another condition, it gives an error.
This - "=IF(C1>1500,"3",IF(C1 > 1000, "2", IF(C1 > 500, "1", "")))" doesn't work at all.
Just edited to add that I want this to only show the 1,2,3,4etc in one cell. I can make it work as individual "IF" conditions in separate cells but that's not as neat as I'd like it to be.
Can anyone troubleshoot for me, or give me a better solution to the formula?
Edit: Changed subject, was Struggling with multiple "IF" formula Make your post understandable by others -- MrProgrammer, forum moderator |