Forum Discussion
Using IF, AND based on multiple criteria
Hello, In my attached spreadsheet, I need a formula for the values in column E. If C=H2S and D=EDM, then the value needs to be B*150 If C=H2S and D=FTM, then the value needs to be B*225 If C...
Monica Bossert - Guess you don't have SWITCH. Check your version https://support.office.com/en-us/article/switch-function-47ab33c0-28ce-4530-8a45-d532ec4aa25e.