Dear Friends,

Can you please help me with the formula, googled and review several threads still not getting the results what i need, please help

I need to Run a Formula in Column D

If there is a value in C1 then C1*103%
else multiply C1*55% of Billed Amount from Tab Price Assesion Column B ( Billed amounts are in Column B of different Tab ) calculating 103% of Fees that is already in ColumnC.

Fees for some of the codes are not there so i need to calculate it with Billed amount that is in another sheet.

please review.

Thank You