Question description:
This user has given permission to use the problem statement for this
blog.
ï?·In cell G1enter Discount, ï?·In cell H1enter DiscountPercent,ï?·In cell I1enter DiscountCost,ï?·In cell J1enter TotalCost, andï?·In cell K1enter Paymentas column headings.
Solved by K. E. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
07/05/2018 - 11:19
Great to meet you, How can I assist you today?
User
07/05/2018 - 11:21
In cell G1enter Discount, In cell H1enter DiscountPercent,In cell I1enter DiscountCost,In cell J1enter TotalCost, andIn cell K1enter Payments column headings.
User
07/05/2018 - 11:21
Its a whole assissgnment
Excelchat Expert
07/05/2018 - 11:21
So the goal of this task is to put names of columns?
Excelchat Expert
07/05/2018 - 11:22
Or to do the calculations upon some data set?
User
07/05/2018 - 11:22
in columns
User
07/05/2018 - 11:23
do you guys complete assissgnments ?
Excelchat Expert
07/05/2018 - 11:23
No we only answer basic excel questions related to the sheets
Excelchat Expert
07/05/2018 - 11:23
Solve excel formulas
Excelchat Expert
07/05/2018 - 11:23
Etc.
User
07/05/2018 - 11:23
okay
Excelchat Expert
07/05/2018 - 11:24
We cannot do whole assgnments
Excelchat Expert
07/05/2018 - 11:24
But we can help with them partailly
Excelchat Expert
07/05/2018 - 11:25
If there is such a need
User
07/05/2018 - 11:26
In G2 insert an if function that displays discount with Y0r N if the unit cost is less
Excelchat Expert
07/05/2018 - 11:26
If you only divide it to small parts, and could clarify the question, we will be happy to help
User
07/05/2018 - 11:26
or equal to 100
Excelchat Expert
07/05/2018 - 11:26
Which cell should it be related to?
User
07/05/2018 - 11:27
insert if funstion
User
07/05/2018 - 11:27
function
Excelchat Expert
07/05/2018 - 11:28
It is in G2:)
Excelchat Expert
07/05/2018 - 11:29
IF(logical_expression, value_if_true, value_if_false)
Excelchat Expert
07/05/2018 - 11:29
This is the body of IF function
Excelchat Expert
07/05/2018 - 11:29
Logical_expression is a place you put your logical expression
Excelchat Expert
07/05/2018 - 11:30
In this case
Excelchat Expert
07/05/2018 - 11:30
<=100
Excelchat Expert
07/05/2018 - 11:30
,value_if_true is where you put what the cell should display if the logical expression is TRUE
Excelchat Expert
07/05/2018 - 11:31
value_if_false is what to display if the logical expression is FALSE
Excelchat Expert
07/05/2018 - 11:31
Feel free to download this file
Excelchat Expert
07/05/2018 - 11:31
For further work
Excelchat Expert
07/05/2018 - 11:31
Click on File -> download
Excelchat Expert
07/05/2018 - 11:32
I think this assignment should have some data
Excelchat Expert
07/05/2018 - 11:32
You can work on.
Excelchat Expert
07/05/2018 - 11:32
Feel free to past more parts as a direct question on what should be done in the every step.
Excelchat Expert
07/05/2018 - 11:32
paste*
User
07/05/2018 - 11:33
I was trying to upload but my computer acting up
User
07/05/2018 - 11:33
it
Excelchat Expert
07/05/2018 - 11:33
No problem
Excelchat Expert
07/05/2018 - 11:33
just copy and paste
Excelchat Expert
07/05/2018 - 11:33
the function from here
Excelchat Expert
07/05/2018 - 11:33
Or download this file
Excelchat Expert
07/05/2018 - 11:34
And try to create an IF function form scratch with what I just show you:)
Excelchat Expert
07/05/2018 - 11:34
Is there anything more I could assist you today regarding your original question?
User
07/05/2018 - 11:37
How to expand I1 so that discount cost fit on the cell
User
07/05/2018 - 11:37
typo fit in cell
User
07/05/2018 - 11:38
hello
User
07/05/2018 - 11:39
are you there or should I end the session?
User
07/05/2018 - 11:40
hellooooooooo?
Excelchat Expert
07/05/2018 - 11:40
Hello I am here
Excelchat Expert
07/05/2018 - 11:41
To expand a cell click on the edge of the column
Excelchat Expert
07/05/2018 - 11:41
aHold and drag it
Excelchat Expert
07/05/2018 - 11:42
Or double-click on it so it will auto expand to fit the needed size.
User
07/05/2018 - 11:43
can you show again
Excelchat Expert
07/05/2018 - 11:44
Double click with left mouse button
Excelchat Expert
07/05/2018 - 11:44
on the edge of the column
Excelchat Expert
07/05/2018 - 11:46
Now, I will be going to solve another excel task. After you are done with the file just download it to your desktop so you can have a formula stored there, and please click the red button in the right- top part of the screen.
Excelchat Expert
07/05/2018 - 11:46
Thanks for using Got It Pro and have a great Day!:)
User
07/05/2018 - 11:46
Thanks I give up
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.