If Function reading from another Sheet !

[OceanBlue]

='Sheet2'! IF(C2>99,"yes")

not working for me !

C2 cell is in Sheet2


How can I correct it?

[martindwilson]

=if(sheet2!c2>99,"yes,"no")

[OceanBlue]

Thanks, that is good, it can work, BUT

The value of C2 is set to Percentage ! it is not reading it !

=if(sheet2!c2>99,"yes,"no")

[OceanBlue]

=IF(QTP-2-Create New Prospect!H21>99, "1", "0")

This is my IF Function but when I click enter it is trying to Open a file reference !

Also the cell H21 is a formatted as a Percentage

How can I fix it?

Thanks, that is good, it can work, BUT

The value of C2 is set to Percentage ! it is not reading it !

[day92]

Ocean - do you have a sample spreadsheet you can upload?

[OceanBlue]

Attached,

Notice the first sheet = Aspect RoadMap Cell H3

Trying to read from sheet = QTP-2-Create New Prospect cell H21

Ocean - do you have a sample spreadsheet you can upload?

[martindwilson]

maybe
=IF('QTP-2-Create New Prospect'!H21>0.99, 1, 0) or
=IF('QTP-2-Create New Prospect'!H21>99%, 1, 0)

if sheet name has spaces it must be enclosed in single quotes,
99%=0.99
and you don't need"" around numbers "1","0"

[day92]

You were missing the quote after the sheet name. Try this...

=IF('QTP-2-Create New Prospect'!H21>99, 1, 0)

[OceanBlue]

YES, true, I was missing the comma and 0.99 works

Here is the end result

IF('QTP-2-Create New Prospect'!H21>0.99, 1, 0)

Thanks guys.