Hi everyone,

I have the following formula that switches between adding and multiplying two cells depending on the contents of ResultsUD!$B$105.

I need to put another rule into the If statement that checks if the cell G12 contains ChinaC5 then add the two cells, otherwise follow the formula below.

=IF(ResultsUd!$B$105=0,(IF(ResultsUd!$B$602>5,(D66/1000)*G66,(D66*G66))),(E66+G66))

Would really appreciate some help as I'm just going around in circles!

Thanks