May 23 2022 08:14 AM
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.
May 23 2022 08:36 AM
Please provide more detailed information, for example post the formula you're using and indicate what you want to change.
May 23 2022 08:50 AM - edited May 23 2022 08:51 AM
=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.
May 23 2022 09:43 AM
May 23 2022 09:53 AM
Glad to hear that!