Forum Discussion

petergraham250's avatar
petergraham250
Copper Contributor
Nov 23, 2020

IFS function not working

I have transferred a Googlesheet to excel and found the IFS functions aren't working.  I have read a lot one the posts on this forum and made sure I am one the latest version of Excel and using Offic...
Excel on Mac
JKPieterse's avatar
JKPieterse
Silver Contributor
Nov 23, 2020
Can you show the formula please? Or -even better- upload a sanitized copy of the file?
  • petergraham250's avatar
    petergraham250
    Copper Contributor
    Nov 24, 2020

    JKPieterse below the calculation.  Difficult for me to upload the file as it is a company confidential document.  Thank you.

     

    =IFS(OR($E1888<$F$6,period_assumptions<$F$6,MONTH(period_assumptions)<>MONTH($E1888),$E1888>period_assumptions),0,period_assumptions=$E1888,W1042*VLOOKUP(YEAR(period_assumptions),table_premium_charged,2,FALSE),AND(MONTH(period_assumptions)=MONTH($E1888),period_assumptions>$E1888),W1324*VLOOKUP(YEAR(period_assumptions),table_premium_charged,2,FALSE))

    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Nov 24, 2020
      What is the definition of period_assumptions?
      • petergraham250's avatar
        petergraham250
        Copper Contributor
        Nov 25, 2020

        JKPieterse period_assumptions is table (across columns) of dates from July 2020 to June 2027 in the format mmm-yy.

Resources