Forum Discussion
Advice Needed: Performing complicated nested if calculation
Hi there, I am trying to find a way to automatically calculate a sum, based on a number of variables. I can't figure out whether an extremely long series of nested Ifs in a Formula, or a VBA functio...
Thank you both for the suggestions and advice! I am the kind of Excel user who figures out how to do things with the knowledge I have and a bit of Googling. Prior to this exchange, I didn't know the IFS() formula existed, nor had I encountered the term LAMBDA. I definitely didn't know there was a way to write logic code without using VBA! You've both given me things to look into and explore, so thank you very much 😃