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 an...
=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.