Forum Discussion
pulling diferent conditions with the IFS fuction
Hello I am trying utilize the IFS function to calculate additional footages pas a certain Unit criteria. based on the length of a short, medium, or long unit and whether it is a normal unit, branch u...
=IFS(AND(G4="long",F4>120),F4-120,AND(I4="branch",F4>25),F4-25,AND(I4="transfer",F4>5),F4-5)
or
=IFS((G4="long")*(F4>120),F4-120,(I4="branch")*(F4>25),F4-25,(I4="transfer")*(F4>5),F4-5)
It works in my sheet when i use the formula like this.