**Question description:**

*This user has given permission to use the problem statement for this blog.*

i'm making a profit and loss sheet and i have a fee that only happens when i sell an item. so its 2.9%+.30 of a total of another cell. is there away to make a cell with this formula without it adding the .30 to the total if there is sale price for the item?

Solved by I. J. in 18 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
07/12/2017 - 11:01

hELLO!

Excelchat Expert
07/12/2017 - 11:01

Hello

User
07/12/2017 - 11:01

hi

Excelchat Expert
07/12/2017 - 11:01

Welcome to excelchat

User
07/12/2017 - 11:01

thanks

Excelchat Expert
07/12/2017 - 11:01

can you show me the data where you want this formula?

User
07/12/2017 - 11:02

sure i will try lol

Excelchat Expert
07/12/2017 - 11:02

ok

Excelchat Expert
07/12/2017 - 11:02

also you can attach your excel file if you want

Excelchat Expert
07/12/2017 - 11:03

from attach button beside your chat textbox

User
07/12/2017 - 11:03

im just starting on it so there isn;t much on it

Excelchat Expert
07/12/2017 - 11:03

ok

Excelchat Expert
07/12/2017 - 11:03

feed some demo data

User
07/12/2017 - 11:05

so what i need is it not to have column 2 work if there is a zero in column 1

Excelchat Expert
07/12/2017 - 11:06

ok

Excelchat Expert
07/12/2017 - 11:06

please wait

User
07/12/2017 - 11:06

so i don't get a negitive in column 3

User
07/12/2017 - 11:06

ok thanks

Excelchat Expert
07/12/2017 - 11:06

ok i got it

Excelchat Expert
07/12/2017 - 11:07

this is what you wanted?

User
07/12/2017 - 11:07

yeah i think so

Excelchat Expert
07/12/2017 - 11:07

ok

Excelchat Expert
07/12/2017 - 11:08

if you want i can give direct 1.9333 in column 2 only

Excelchat Expert
07/12/2017 - 11:08

no need to have an extra column

User
07/12/2017 - 11:09

what it is is a is a sale price b is paypal fees and c is the total

Excelchat Expert
07/12/2017 - 11:09

ohh ok i got it

Excelchat Expert
07/12/2017 - 11:09

do you need further help regarding this matter?

User
07/12/2017 - 11:10

one more question with it

Excelchat Expert
07/12/2017 - 11:10

ok ask

User
07/12/2017 - 11:10

is there a way to make it a check box so when it is clicked it will do the formula for the paypal fee in the c column?

Excelchat Expert
07/12/2017 - 11:11

would you like it to be a list as applicable or not applicable instead

User
07/12/2017 - 11:12

what do you mean?

Excelchat Expert
07/12/2017 - 11:12

instead of checkbox

Excelchat Expert
07/12/2017 - 11:12

i will add a list in column d

Excelchat Expert
07/12/2017 - 11:12

where you will have to select applicable or not applicable

User
07/12/2017 - 11:13

i'mthinking like you check the box then the formula for the fee is added to my total in c'

Excelchat Expert
07/12/2017 - 11:14

ok please wait let me check it

Excelchat Expert
07/12/2017 - 11:14

actually

User
07/12/2017 - 11:14

ok

Excelchat Expert
07/12/2017 - 11:15

this can only be done using vba

User
07/12/2017 - 11:15

what is that

Excelchat Expert
07/12/2017 - 11:15

which i will not recommend to you for this small sheet

User
07/12/2017 - 11:15

ok thanks

Excelchat Expert
07/12/2017 - 11:15

vba is coding language

Excelchat Expert
07/12/2017 - 11:16

what about you type 1 when you need a formula

User
07/12/2017 - 11:16

ok thanks for your help

Excelchat Expert
07/12/2017 - 11:16

or null when you dont need it?

Excelchat Expert
07/12/2017 - 11:16

your most welcome

Excelchat Expert
07/12/2017 - 11:16

thank you for choosing excelchat

Excelchat Expert
07/12/2017 - 11:17

please rate after session ends

Excelchat Expert
07/12/2017 - 11:17

please end this session from your end if you dont have further queries regarding this matter

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*