Forum Discussion

Fiona Sawyers's avatar
Fiona Sawyers
Copper Contributor
Oct 26, 2018
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 ...
excel
Formulas and Functions
Fiona Sawyers's avatar
Fiona Sawyers
Copper Contributor
Oct 26, 2018

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

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 27, 2018

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")

 

 

 

  • Fiona Sawyers's avatar
    Fiona Sawyers
    Copper Contributor
    Oct 29, 2018

    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

Resources