Forum Discussion
Adding if formulas together for specific text combinations
Help please. I need a formula to return specific text based off two selections. i can get the first formula to work but can’t get the varaitions to work based on a combination of high, med and low se...
It would help if you gave more actual details but since you didn't all I can say is there are 3 (and likely more) functions to look at:
1) the IF() statement, which I suppose you already know. You can 'chain' IF statements together:
=IF( AND(a1="high", b1="high"), "high-high result", IF ( AND(a1="high", b1="med"), "High-med result", ...) )
In the above example I show if a condition is true then it gives that result but if false it 'falls' into the next IF() statement. You could just as easily chain on the TRUE condition side also or instead.
2) the IFS() statement, this is just like the IF() statement but you don't have to keep repeating the IF and don't have to count the "( )":
=IFS( AND(a1="high", b1="high"), "high-high result", AND(a1="high", b1="med"), "High-med result", ... , TRUE, "default output" )
note the last pair I use TRUE so anything that didn't pass a prior condition will get the "default output" result
3) SWITCH() statement will take ONE input and then 'switch' the output based on it. So for example:
=SWITCH( a1 & b1, "highhigh", "high-high result", "highmed", "high-med result", ....)
In this example I text joined the values from a1 and b1 to create a single text value to do the comparison.
there are many other ways you can 'play' with those functions and many other functions but hopefully that helps.
1) the IF() statement, which I suppose you already know. You can 'chain' IF statements together:
=IF( AND(a1="high", b1="high"), "high-high result", IF ( AND(a1="high", b1="med"), "High-med result", ...) )
In the above example I show if a condition is true then it gives that result but if false it 'falls' into the next IF() statement. You could just as easily chain on the TRUE condition side also or instead.
2) the IFS() statement, this is just like the IF() statement but you don't have to keep repeating the IF and don't have to count the "( )":
=IFS( AND(a1="high", b1="high"), "high-high result", AND(a1="high", b1="med"), "High-med result", ... , TRUE, "default output" )
note the last pair I use TRUE so anything that didn't pass a prior condition will get the "default output" result
3) SWITCH() statement will take ONE input and then 'switch' the output based on it. So for example:
=SWITCH( a1 & b1, "highhigh", "high-high result", "highmed", "high-med result", ....)
In this example I text joined the values from a1 and b1 to create a single text value to do the comparison.
there are many other ways you can 'play' with those functions and many other functions but hopefully that helps.