**Question description:**

*This user has given permission to use the problem statement for this blog.*

I am trying to put in an IF formula and although it works on all the other excel sheets I've worked on it is impossible to get it started in this new tab.
The problem would be :
=IF(G9="ENT.PSAB",N9,"")
It simply doesn't do anything, when what I want is the debit amount to be repeated in another column with the same amount. Save typing in manually.

Solved by C. J. in 60 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
07/06/2018 - 01:37

Hello

User
07/06/2018 - 01:37

hello

Excelchat Expert
07/06/2018 - 01:37

Thanks for using Got It Pro

User
07/06/2018 - 01:37

can you help me?

Excelchat Expert
07/06/2018 - 01:37

Sure

Excelchat Expert
07/06/2018 - 01:38

I am here to be of assistance

Excelchat Expert
07/06/2018 - 01:38

Please give me a minute to read through the question

Excelchat Expert
07/06/2018 - 01:39

It seems you are having problems with IF formular on a tab

User
07/06/2018 - 01:39

yep

Excelchat Expert
07/06/2018 - 01:39

Can you please upload the sheet for review or would you rather I explain the solution

Excelchat Expert
07/06/2018 - 01:39

?

User
07/06/2018 - 01:40

I would rather explain on the sheet here

Excelchat Expert
07/06/2018 - 01:40

Ok

Excelchat Expert
07/06/2018 - 01:40

=IF(G9="ENT.PSAB",N9,"")

Excelchat Expert
07/06/2018 - 01:41

I think you want to compare the value of cell G9

Excelchat Expert
07/06/2018 - 01:41

with a fixed value "ENT.PSAB"

Excelchat Expert
07/06/2018 - 01:41

If the value is true, the cell should return value of Cell N9

Excelchat Expert
07/06/2018 - 01:42

if the test is false, the cell should return as an empty test

User
07/06/2018 - 01:42

I have a row of columns which all have descriptions in. To the left of these columns I would have an amount in say, column C which relates to say, F and I want to be able automatically input the same amount I have put in column C

Excelchat Expert
07/06/2018 - 01:43

Ok.

Excelchat Expert
07/06/2018 - 01:44

If I get you right please, you want to copy the value of Column C to F based on a criteria

User
07/06/2018 - 01:44

In otherwords, every time I put an amount in Column C it is reflected automatically in the appropriate headed column eg. Column C = Travel so every time I input into the amount coloumn it will automatically repeat in the appropriate column

User
07/06/2018 - 01:44

Yes

User
07/06/2018 - 01:45

I have been using as an example

User
07/06/2018 - 01:46

=IF(C44="Travel-PSAB",F44," ")

Excelchat Expert
07/06/2018 - 01:46

Ok. Thanks

Excelchat Expert
07/06/2018 - 01:47

Have you defined a value for "Travel"?

Excelchat Expert
07/06/2018 - 01:47

Or does it relate to a cell?

User
07/06/2018 - 01:47

It relates to a cell

Excelchat Expert
07/06/2018 - 01:48

Ok. Good

User
07/06/2018 - 01:48

The amounts are different they change

User
07/06/2018 - 01:48

The above formula worked on another of my worksheets so why isn't working now??

Excelchat Expert
07/06/2018 - 01:49

Can you please replace the variable "Travel" with a cell and confirm if the formular works?

Excelchat Expert
07/06/2018 - 01:49

Excel will return error if it is unable to locate the value of a referenced variable

User
07/06/2018 - 01:49

Sorry, I don;t understand

Excelchat Expert
07/06/2018 - 01:49

Ok

User
07/06/2018 - 01:50

Yes it does - excel keeps telling me to put an apostrophe in front of the first =

User
07/06/2018 - 01:50

This does not cure the problem - it does nothing

Excelchat Expert
07/06/2018 - 01:51

for example, replace =IF(C44="Travel-PSAB",F44," ") with =IF(C44="A1-PSAB",F44," ")

Excelchat Expert
07/06/2018 - 01:52

Please make sure A1 contains a numerical figure for this test

User
07/06/2018 - 01:52

Why A1?

Excelchat Expert
07/06/2018 - 01:52

The purpose is to test variable "travel" for validity

Excelchat Expert
07/06/2018 - 01:52

It can be any cell number that contains a number

User
07/06/2018 - 01:52

If you see my table opposite - I want that 12.70 to automatically appear in column G18

Excelchat Expert
07/06/2018 - 01:53

Ok. I can see the Document preview now

Excelchat Expert
07/06/2018 - 01:53

Thanks

User
07/06/2018 - 01:54

so that every time I input an amount that relates to PSAB-TRAVEL

Excelchat Expert
07/06/2018 - 01:54

Thanks for extending the time

User
07/06/2018 - 01:54

it appears also under the heading PSAB-TRAVEL

Excelchat Expert
07/06/2018 - 01:54

From the preview

User
07/06/2018 - 01:56

are you asking me a question?

Excelchat Expert
07/06/2018 - 01:56

Yes Please

Excelchat Expert
07/06/2018 - 01:57

The referenced Cell F44 does not contain any value

User
07/06/2018 - 01:57

Oh please, that was an example, NOT LITERALLY!! I have shown you opposite what I am looking for

User
07/06/2018 - 01:58

Are you English speaking>

Excelchat Expert
07/06/2018 - 01:58

Yes please

User
07/06/2018 - 01:58

or is this your second language you keep saying yes please -

Excelchat Expert
07/06/2018 - 01:59

I speak English. Please allow me explain what I mean

Excelchat Expert
07/06/2018 - 01:59

The IF function can only perform a logical test and return one value for a TRUE result, and another for a FALSE result.

Excelchat Expert
07/06/2018 - 01:59

For example

Excelchat Expert
07/06/2018 - 02:00

Please see my example in Cell B22

User
07/06/2018 - 02:00

Okay before the example. Please type for me the exact excel formula to give me what I have explained above.

Excelchat Expert
07/06/2018 - 02:01

I compared the value of Cell F15 and B18

Excelchat Expert
07/06/2018 - 02:01

If they are the same, the excel should return F18 but if not, the excel should return G18

User
07/06/2018 - 02:02

I really don't think you understand what I require,. I give up.

Excelchat Expert
07/06/2018 - 02:02

Please don't

Excelchat Expert
07/06/2018 - 02:02

I am here to assist please

User
07/06/2018 - 02:03

BUT YOU DON'T UNDERSTAND.

Excelchat Expert
07/06/2018 - 02:03

Please explain one more time. Please

Excelchat Expert
07/06/2018 - 02:03

I am sorry I didn't get your initial explaination

User
07/06/2018 - 02:04

IF I PUT £20.00 in column C AND IT IS FOR ENT.PSAB THE COLUMN WITH ENT.PSAB WILL AUTOMATICALLY HAVE £20.00. AND WHEN I PUT A DIFFERENT AMOUNT IN FOR ENT.PSAB IT WILL GO AUTOMATICALLY INTO ENT.PASB COLUMN

Excelchat Expert
07/06/2018 - 02:05

Ok Sir. I believe I get you now

Excelchat Expert
07/06/2018 - 02:06

You want to reflect the value of Column C in Column F if the value is same with ENT.PSAB

Excelchat Expert
07/06/2018 - 02:06

Am I right Please?

Excelchat Expert
07/06/2018 - 02:06

I am sorry this is taking your time but please confirm if it is right

Excelchat Expert
07/06/2018 - 02:07

Hello Sir

User
07/06/2018 - 02:07

yes, but bearing in mind the amounts will change but the description does not

Excelchat Expert
07/06/2018 - 02:07

Ok Sir

User
07/06/2018 - 02:08

PLEASE WHAT FORMULA DO I PUT IN FOR THIS WORK

Excelchat Expert
07/06/2018 - 02:08

I will type it right away

Excelchat Expert
07/06/2018 - 02:09

Apologies for the delay

User
07/06/2018 - 02:13

PERHAPS YOU CAN SEND ME THE FOMULA WHEN YOU HAVE WORKED IT OUT.

User
07/06/2018 - 02:13

THANKS

User
07/06/2018 - 02:13

this is taking far too long for someone who should be a whizz on excel

Excelchat Expert
07/06/2018 - 02:13

Ok Please

User
07/06/2018 - 02:13

patricia@peterblincow.com

Excelchat Expert
07/06/2018 - 02:15

Apologies for the delay please

Excelchat Expert
07/06/2018 - 02:15

Please use the formular below

Excelchat Expert
07/06/2018 - 02:16

=if(B7=$E$1,C7,"")

Excelchat Expert
07/06/2018 - 02:17

I have inputted the formular into the excel and extended it to roll 55

Excelchat Expert
07/06/2018 - 02:17

Please confirm if that would be all or if you have another question

Excelchat Expert
07/06/2018 - 02:19

Hello Sir

Excelchat Expert
07/06/2018 - 02:19

Are you there please?

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