**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.*