Thank you so much for the reply and the time. I am creating a sheet that calculates tips for bartenders. There could be 1,2, or 3 bartenders on a shift (B12) and they share their tip with a barback. That part of the equation is IF($B$11=1,$S$12,IF($B$11=2,$S$13,IF($B$11=3,$S$14 - S column contains the formula for calculating the tip
But if there is no barback IF(B32)=”0”then they would receive a different amount calculated in the "T" column IF($B$11=1,$T$12,IF($B$11=2,$T$13,IF($B$11=3,$T$14,
Bookmarks