I need to update the below formula to include this piece: IF(AND(Rate_Card_Selection="Company B",C19="Remote Access Points"),0,150))
What is the correct way to nest the IF AND function into the below?
=@IFS(C19="Company A (London)",325,Inputs!C19="Remote Access Points",150,TRUE,VLOOKUP(Rate_Card_Selection,DB!M:S,7,FALSE))
What is the correct way to nest the IF AND function into the below?
=@IFS(C19="Company A (London)",325,Inputs!C19="Remote Access Points",150,TRUE,VLOOKUP(Rate_Card_Selection,DB!M:S,7,FALSE))