Using 'if' in formulas

formulas

#1

Hi, how can I use an ‘if’ formula? For instance… If bra cup size = A, then the degrees of the angle of dart will be 35 degrees and if B, it will be 45 degrees… Are multiple conditions at all possible?


#2

You cannot. Instead use ternary operator ?:.

Like this: a > b ? x : y


#3

@dismine, Thank you :grinning: I’ll play around with it.


#4

I’m not managing. I have this: ((highbust_circ-bust)<2.5>0)+258.775

And I’d like to add the 2nd step, which would be this: ((highbust_circ-bust)<5>2.5)+252.644

But as soon as I place a “?” or “:”, I get an error.

Please, can you help me?


#5

Your formula is wrong. Can you write your idea with if statement and i will help you to convert it? Because now i don’t understand the idea.


#6

Sure, If(((highbust_circ-bust) ‘is less than’ <2.5 ‘but larger than’ >0) then ‘the degrees’ 259.775 else If(((highbust_circ-bust) ‘is less than’ <5 ‘but larger than’ >2.5) then ‘the degrees’ 253.444 else If(((highbust_circ-bust) ‘is less than’ 7.5< ‘but larger than’ >5) then ‘the degrees’ 247.787

In the image, I’ve worked out the degrees by Inch1; 2 through to 5, which at the outer side of the dart.

So the actual degrees could also be the angle of the lines.


#7

((highbust_circ-bust) >0 && (highbust_circ-bust) <2.5) ? 259.775 : ((highbust_circ-bust) >=2.5 && (highbust_circ-bust) <5) ? 253.444 : 247.787

I don’t know if such construction will work.

You should remember one thing. There must be always a result.


#8

Thank you very much :smile: I’m going to try it right now.


#9

No, it doesn’t work. It definitely doesn’t like the question mark


#10

You are wrong. The formula works. Check error message. Just point a mouse pointer above text “Error” and wait tooltip with message.


#11

Aaaaahhhh… once again… Pure genius :heart_eyes: Thank you very, very much.