Advertisement
Guest User

Untitled

a guest
Feb 20th, 2019
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.21 KB | None | 0 0
  1. =INDEX(scale1!$F$2:$F$10,MATCH($A1,scale1!$D$2:$D$10,1)+1)
  2.  
  3. =MAX(70,550*15%)
  4. =MAX(70,82)
  5. =82
  6.  
  7. =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