Thanks in advance for the help.
A1 = "Flute"
B1 = "Glue" or "Tape"
C1 = 10
D1 = Answer
I need help with an if statement.
C1 = 10, add 1/8 if A1 = Flute, if not add 1/4
At the same time I need to know, AND/OR?
if B1 = Glue or Tape, then add 3/16 to the overall number
Tricky part, if A1 does not equal Flute it should be 1/4 added to C1, I would like if B1 = Glue or Tape then add on 5/16 because Flute is not there. Below is better explanation.
A1: Flute
B1: Glue
C1: 10 + 1/8 + 3/16
A1:
B1: Glue
C1: 10 + 1/4 + 5/16
A1: Flute
B1:
C1: 10 + 1/8
A1: blank or another word
B1: blank or another word
C1: 10 + 1/4
Thanks for the help.
Kevin
Bookmarks