I need a formula as follows: IF B6 says "Can it be repurposed" AND G6 says "Yes", true="Do we have usage rights?", false value = "Can it be created locally?" However IF B6 says "Can it be created locally?" and B6 says "Yes", true="What is the timeframe", false = "No support available" I have tried the following, but it returns the error "Too many arguments" =IF(AND(B6="Can it be repurposed?",G6="Yes"), "Do we have usage rights", "Can it be created locally?", IF(AND(B6="Can it be created locally?",G6="Yes"), "What is the timeframe", "No support Available ")) Essentially I need two IF,AND statements in one formula
Solved by K. F. in 27 mins