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
I'm not sure what the logic described covers all possible combinations, now it looks like
For the above the formula could be
=IFS((D2="Teachers Main Scale")*(E2=6),"=>Upper Pay Spine",(H2>=2)+(H2>=1)*(D2="Teachers Main Scale")*(E2>1),"=>" & E2+1,TRUE,"not now")
Hi Sergie,
Thank you for taking the time to look at my problem and send me through a resolution. I have used another contributors help for the main problem but I am going to look at using some of your solution for the next payscale scale point.
Thanks again,
Fiona