How to fix my nest IF , OR function - Microsoft Community

i created nested function using if statements , or statements. computer first function correctly multiplying 20% if b3 equals bartender or manager... second part if b3 equals "minbartender" multiply 10% otherwise return value of zero.. reason second section returns value 0 if b3= minbartender reason it's not recognizing second-half i've written 2 different ways below must missing something? i'm not getting errors excel idk whats wrong ......please help!

=round(if(or(b3="bartender",b3="manager"),(d3+e3)*20%),or(if(b3="minbartender",(d3+e3)*10%,0)))

=round(if(or(b3="bartender",b3="manager"),(d3+e3)*20%),if(b3="minbartender",(d3+e3)*10%,0))

hi mitch,

 

based on understanding, trying achieve followings:

1.if b3 equals bartender or manager, returns result of (d3+e3)*20%.

2.if b3 equals minbartender, returns result of (d3+e3)*10%.

3.if b3 equals other values above, return 0.

4.put round function result.

 

if understanding correct, can try following formula see if meets requirement:

=round(if((or(b3="bartender", b3="manager")), (d3+e3)*20%, if(b3="minbartender",(d3+e3)*10%, 0)),2)

 

note need input number num_digits round function. can change number meet requirement. learn more round function, please refer round function.

 

regards,

joanne

Office / Excel / Mac / Office 2011 for Mac