Adding an Equation to an Existing equation

Copper Contributor

Currently working on a project where I am wanting to use an =IFS equation, but for one entry in the equation, I am needing an instance of if cell1>cell2, use cell1, but if not use cell2. I am a novice and may be missing something, every time I try to nest an =IF equation within the =IFS it pops up an error.  Any help would be appreciated. 

4 Replies

@Jfantonovitch 

Please provide more detailed information, for example post the formula you're using and indicate what you want to change.

=IFS(I11="Barbarian", K12+N10, I11="Bard", K17+N10, I11="Cleric", K16+N10, I11="Druid", K16+N10, I11="Monk", K13+N10,I11="Paladin", K17+N10, I11="Ranger", K13+N10, I11="Rogue", K13+N10, I11="Sorcerer", K17+N10, I11="Warlock", K17+N10, I11="Wizard", K15+N10, I11="Fighter", )

On the very end I am wanting to add if K12>K13, use K12, if not, use K13 and then add N10 to that result.

I figured out where my issue was, and solved it. Thank you very much for the response though!

@Jfantonovitch 

Glad to hear that!