Ok so what I’m trying to do (see column L) is say, if Hospital B’s ALOS (average length of stay) is 10% higher than Hospital A then put “higher”; if 10% lower then put “lower”; but if it’s within 10% either side (high or low) then I want it to say “equivalent”. BUT also, some might not h![enter image description here][1]ave episodes at both sites so ALOS = 0 so ignore in that and put “xyz”
Current formula is: =IF(G7=E7+L1,"Equivalent ALOS",IF(G7=E7-L1,"Equivalent ALOS",IF(G7>E7+L1,"Higher ALOS than Eastern",IF(G7<E7-L1,"Lower ALOS than Eastern","N/A"))))
formula.PNG
Bookmarks