Creating a formula conditioned on an adjacent column

I have created a spreadsheet to calculate net donations for a newly created charitable cause. We have received donations via cash, checks, and through Facebook and PayPal. While donations through FB come to us in full, PayPal charges 2.2% + .30 per transaction, so the calculation of net proceeds from PayPal is =C5-(C5*0.022)-0.3 .

In the column next to the “Net Donation” column I want to insert an if/then formula that’s conditioned on making the appropriate deductions IF the source of the funds is PayPal. I’ve tried creating what to me seems like a sensible syntax for the formula but the spreadsheet doesn’t even know it’s supposed to be a formula.

Is there a way to put such a formula in the “I” column based on the source designated in the “H” column? I’ve attached a screen clipping. If it is possible, would you mind writing that formula for me? I don’t use Excel very often and have never before needed to create a conditional formula.
I've tried to attach a screen clipping but can't seem to do that. so here are the column headings pasted as text:




-----A----------------B------------C----------D----------E---------------F--------------G-----------H------------I
Donated by Address Amount Contact Blank Total collected: $$$$ Source Net Donation


F And G aren't really columns. F is a label for G, which is just a tally of everything in Column I



Getting those columns to format correctly seems to be impossible even with supposedly monospaced fonts, so I'll just hope it's obvious from what I've printed here.

Maybe
=IF(H5="Paypal",C5*0.978-0.3,C5)

Thanks, but that didn't quite work. I guess what I need is an If/then/ELSE statement, one that does a calculation based upon another column equaling "PayPal" and an else statement that simply pastes 100% of the donated amount into that column if the other column doesn't equal "PayPal." Then I'd want to copy that statement/formula to every cell in the column. It's not crucial if I can't create that kind of formula; it was just an "ideal world" scenario that passed through my mind.

In what way doesn't it work?

You know what? I spoke hastily. I didn't properly copy your formula into the spreadsheet the first time. After reading your response I went back and did it again. This time I copied it into the right location and it worked perfectly. Thank you! And I thought I figured out how I could post a screenshot to this forum, so I tried to post a link to one. Then I saw the message that I'm not allowed to post links until I've posted a few times. Anyway, let it suffice for me to say that your formula did in fact work and I'm most appreciative of your help.

Glad to help & thanks for the feedback