# Excel - COLUMN Function Problem - Expert Solution

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, andIn 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
Excelchat Expert 07/05/2018 - 11:31
For further work
Excelchat Expert 07/05/2018 - 11:31
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
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.

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.