Forum Discussion

Janedb's avatar
Janedb
Iron Contributor
Jul 20, 2023
Solved

Combining IF statement

Good day all, I am trying to combine two IF statements but cant get it to work. It needs to find the date and the allocated values for that date and only then follow the calculation formula.   1. =...
excel
  • HansVogelaar's avatar
    HansVogelaar
    Jul 21, 2023

    Janedb 

    Here is a version that will work in Excel 2013:

     

    =IFERROR(VLOOKUP($B$1, Table6, 3, FALSE)+(A3-VLOOKUP($B$1, Table6, 2, FALSE))*VLOOKUP($B$1, Table6, 4, FALSE), "Date Not Found")

HansVogelaar's avatar
HansVogelaar
MVP
Jul 21, 2023

Janedb 

Here is a version that will work in Excel 2013:

 

=IFERROR(VLOOKUP($B$1, Table6, 3, FALSE)+(A3-VLOOKUP($B$1, Table6, 2, FALSE))*VLOOKUP($B$1, Table6, 4, FALSE), "Date Not Found")

Janedb's avatar
Janedb
Iron Contributor
Jul 21, 2023
Awesome!!! Thank you.

Resources