Sales Record Sheet total with certain amount off or percentage off

[Swaski]

Hello everyone, I've been a lurker here for some time but this is my first time posting. Im still a novice with excel, so I hope someone can lend a hand with my problem. Thanks in advance!

I'm creating a sales record chart to keep daily transactions with individual columns for quantity, original price, amount off, percentage off, and total.

Since there will only be 1 type of discount per transaction, either amount off or percentage off, the total will subtract from which ever column has data.

Can someone please point me toward the right direction in solving this?

[gmr4evr1]

Quick stab at it here but, something like this?..
Swaski Record Sheet total off.xlsx

Change the amount off or % off column to see the total change.

[Swaski]

Hi gmr4evr1, thanks for helping out!
The amount off works but percentage is showing the % discount, not paid total.

[Swaski]

Nevermind. Just need to subtract total to the discount and got it. Thanks so much. Rep'd.

[gmr4evr1]

Dang, just got the new formula for you. Oh well, here it is anyway, just in case someone else needs it
Replace the formula in E2 of my sample sheet with this one....

=IF(C2="",A2*B2-B2*D2,A2*B2-C2)