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.