If Formulae

[philb99]

Hi - I have 2 Columns on a tab

One columns takes information from another tab by a simple ="name of tab" "cell" + "name of tab" "cell" etc

Second Column I manually key information into - They should both equal the same

In the third Column I am trying to write an IF Formulae but although they are reporting the same I get my negative response = Check
IF(C13=C13,"ok","check")

What do I need to do please

 

[hrayani]

Hi - I have 2 Columns on a tab

One columns takes information from another tab by a simple ="name of tab" "cell" + "name of tab" "cell" etc

Second Column I manually key information into - They should both equal the same

In the third Column I am trying to write an IF Formulae but although they are reporting the same I get my negative response = Check
IF(C13=C13,"ok","check")

What do I need to do please

There is a typo error in the formula.. C13 = C13 .... that might be causing the problem

but even in the said case you should always return OK as an answer

try to post a sample data or a screenshot - that will be easier to help

 

[philb99]

Thanks - that's me trying to type the formulae into the thread and doing it incorrectly only.
My formulae in Column A is the following and in Col B I manually key in data

('3.1a QA - 3.1e'!CB38+'3.1a QA - 3.1e'!CB51-'3.1a QA - 3.1e'!CB39-'3.1a QA - 3.1e'!CB52)/('3.1a QA - 3.1e'!CB38+'3.1a QA - 3.1e'!CB51)

 

[hrayani]

Thanks - that's me trying to type the formulae into the thread and doing it incorrectly only.
My formulae in Column A is the following and in Col B I manually key in data

('3.1a QA - 3.1e'!CB38+'3.1a QA - 3.1e'!CB51-'3.1a QA - 3.1e'!CB39-'3.1a QA - 3.1e'!CB52)/('3.1a QA - 3.1e'!CB38+'3.1a QA - 3.1e'!CB51)

I still don't see it as a formula.......... try to copy the exact formula which you have in Column A

 

[philb99]

Hi that is the instruction in Col A - I am looking for information in the tab 3.1a QA - 3.1e and Cell CB38 and so on

In Col B the IF formuale is =IF(B2=A2,"ok","check")

Thanks

 

[hrayani]

Sorry friend, I am finding it difficult to understand.
try to post a screenshot of your data
or you can upload your workbook to a sharing site and share the link here