Excel - IF Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.