• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel formula

ridwanr

New Member
Hi all,

Am looking for an excel formula in which the Cost Pub and Cost per Contract if MESSI and Rooney is 0 and #DIV/0! then take the (column C) figues that is Total Cost as the answer.

Pls see attached file for better understanding.

Thanking you for your help

Regards,
Ridwan
 

Attachments

  • Ridwan example3.xlsx
    11.4 KB · Views: 3
hello-You Can To Use This Formula Start From Cell F2
Code:
=IF(AND($A2="Messi",$B2=0),$C2,IF(AND($A2="Rooney",$B2=0),$C2,(C2+D2)/B2))
 

Attachments

  • Ridwan example1.xlsx
    12.1 KB · Views: 7
Back
Top