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...
Perhaps
=IFS(
I4 = "Barnch", MAX(0, F4-5),
I4 = "Transfer", MAX(0, F4-25),
G4 = "Long", MAX(0, F4-120),
TRUE, 0
)if I understood the logic correctly.