Forum Discussion
Solved
Help with Excel IF and AND or OR functions
Hi there, I'm new to this group so I'm hoping that someone can help me... I have a spreadsheet with data concerning staff pay scales, scale point and start date and need to be able to put in ...
Hello ,
Please check the attached file. I tried to combine several conditions all together how ever the results shoudl be checked throughly
Hi Erol,
Thank you for your quick response, I replied to your email but I have realised you probably won't get it so I have attached the file here in the hope that you can see it. As I said in my first post I have already put some formula into it but feel free to remove/amend.
Regards,
Fiona
Hello ,
Please check the attached file. I tried to combine several conditions all together how ever the results shoudl be checked throughly
Hi Erol,
This is amazing - thank you so much. I have tweaked it a little bit as the formula for Teachers Upper didn't quite work - just because the s was missing from Teachers.
I've tested all of the different scenario's and am happy that I'm getting the correct result returned.
I'm just working on getting the next scale point to show where someone is either eligible to move up to the next scale or eligible to apply for the next scale.
Your help has been invaluable, thanks once again!
Regards,
Fiona
Hi again Erol,
I have used the formula you helped me with and added to it to work out the next scale as per the original brief:
If a teacher is on teachers main 1 - 5 they can go up onto the next scale and that would be 2-6
If a teacher is on teachers main 6 they can apply to go up to teachers upper and this is now returning a next scale of TU1
If a teacher is on teachers upper for more than 2 years they can apply to go up onto the next scale which is returning 2-4 but the user is now asking if it would be possible to return Top of Scale where a teacher is on teachers upper scale 3 as they can't go up any further.
I've tried to amend the formula in column I to pick up this information but I can't make it work correctly so I think it may be better to be included in column J instead.
Any help would be greatly appreciated!
Thanks in advance,
Fiona
You need to add another "IF" at the end of the nested Ifs. you have a long formula ending with:
=...;"Need 1 year for next scale application"),))
it should be:
;"Need 1 year for next scale application"), IF($C3="Teacher Upper","Top Scale","")))