-Percent in formula

N

natei6

Hi,

I'm doing an invoice with a discount column between unit price an
extended price. I want to be able to enter "8" into the discoun
column and deduct 8% from the extended price. This is the formula
have in the extended price column but it only takes $0.08 off th
extended price. How do I amend this formula?

=IF(ISBLANK(C13),"",(B13*F13)-(G13))


Thank God for this forum

Nathan Sargean
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeat formula in new rows 4
percent and dollar formula don't mix 2
Vlookup ? 2
Need for ISERR and ISNA Makes formula too Long 6
Index / Match? Formula Help Please 1
Formula omits adjacent cells error message 4
Need Formula or Function to calculate Margin (reverse of Percent a 1
IF/AND Statement & searching through select data... 1

Top