Forum Discussion
IF or IFS
I need a sum formula for a worksheet where if a cell contains yes then it is worth 25 then if the next cell contains yes then its worth 40.
eg if c2 = yes then its value is 25 plus d2 if yes = 45 and this adds up to show a total value
1 Reply
=IF(C2="yes", 25+IF(D2="yes", 15, 0), 0)
or
=IF(C2="yes", 25+IF(D2="yes", 20, 0), 0)
depending on which part of your question is correct.
