Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =INDEX(scale1!$F$2:$F$10,MATCH($A1,scale1!$D$2:$D$10,1)+1)
- =MAX(70,550*15%)
- =MAX(70,82)
- =82
- =IFERROR(IFS($B1="scale1",MAX(INDEX(scale1!$F$2:$F$10,MATCH($A1,scale1!$D$2:$D$10,1)+1)*10%,70)),"")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement