Forum Discussion
Help with nested ifs formula fiving error N/A
@ Hello, I'm trying to write a formula for below. If the building is "restaurant", and type of systems is C33=YES, C34=YES and C35=YES, then refer savings cell A, else refer to "others" savings ce...
=IFS(F28="Restaurant",IF(AND($C$33="Yes",$C$34="Yes",$C$35="Yes"),Savings!O43,IF(AND($C$33="Yes",$C$34="No",$C$35="Yes"),(Savings!O43+Savings!P43),IF(AND($C$33="Yes",$C$34="Yes",$C$35="No"),(Savings!O43),IF(AND($C$33="Yes",$C$34="No",$C$35="No"),(Savings!O43+Savings!P43+Savings!Q43),0)))),F28="Others",IF(AND($C$33="Yes",$C$34="Yes",$C$35="Yes"),Savings!O44,IF(AND($C$33="Yes",$C$34="No",$C$35="Yes"),(Savings!O44+Savings!P44),IF(AND($C$33="Yes",$C$34="Yes",$C$35="No"),(Savings!O44),IF(AND($C$33="Yes",$C$34="No",$C$35="No"),(Savings!O44+Savings!P44+Savings!Q44),0)))))
This formula works in my sheet.
Savings