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 unit or transfer unit as different factors. the maximum length for a long normal unit is 120 ft, for any length branch unit is 25 ft, and for any length transfer is 5 ft. I came up with the formula below but am not getting the right output. 

=IFS(G4=”long”&F4>120,F4-120,I4=”branch”&F4>25,F4-25,I4=”transfer”&F4>5,F4-5)

PHoto of table for referenced:

​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 unit or transfer unit as different factors. the maximum length for a long normal unit is 120 ft, for any length branch unit is 25 ft, and for any length transfer is 5 ft. I came up with the formula below but am not getting the right output.  =IFS(G4=”long”&F4>120,F4-120,I4=”branch”&F4>25,F4-25,I4=”transfer”&F4>5,F4-5) PHoto of table for referenced:   Read More

​