Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Olivia FordeOlivia Forde 

Create a Case statement with and IF in it

I want to create a CASE statement for a frmula field that does this
if  x or y = true then
A
if x and y = true
B
else
C
JeffreyStevensJeffreyStevens
Wouldn't just nested IF statements work?

IF(OR(A,B),"A",IF(AND(X,Y),"B","C"))

 
Olivia FordeOlivia Forde
Partially works this way But now I find I need it to evaluate all conditions if x and y = true C - 1 if x = true Then C -.5 If y = true then C - 5 else C