Nested IF AND function in IFS function

[Mindre]

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))

 

[jasonb75]

See if this does what you need.

=@IF(C19="Company A (London)",325,IF(Inputs!C19="Remote Access Points",IF(Rate_Card_Selection="Company B",0,150),VLOOKUP(Rate_Card_Selection,DB!M:S,7,FALSE))))

For what it's worth, it is better to use multiple IF's than IFS. It depends largely on any additional functions used with it, but the IFS function can be highly inefficient.

 

[Mindre]

That did it - Appreciate the help!