Adding two IF's together

[ddub25]

I would like to add the two formulas below together. Can anyone help me with the syntax for adding two IF's together?

=IF(B127="Y",COUNTIF(AF127:AQ127,"Y")*Z127,0)

+

=IF(B127="Y",COUNTIF(AF127:AQ127,"Y2")*(Z127*0.42),0)

Thanks.

Dan

 

[jeffreybrown]

Hi Dan,

Could it just be...

=IF(B127="Y",COUNTIF(AF127:AQ127,"Y")*Z127+COUNTIF(AF127:AQ127,"Y2")*(Z127*0.42),0)

 

[ericaindallas]

Not sure what you meant by the "+" sign, if you want to add the two formulas together or if you were illustrating that you want the two formulas combined.

If you want them combined and not added....

=IF(B127="Y",COUNTIF(AF127:AQ127,"Y")*Z127,IF(B127="Y",COUNTIF(AF127:AQ127,"Y2")*(Z127*.42),0))

 

[ddub25]

I wanted to + the two results together and combine the two formulas as Jefferey showed. Thanks Jeff, thats exactly what I wanted.

Dan