IF Statement help

[karobonas]

Hi,
I want to compose an IF Statement that will do the following:
IF sheet 1 Q27 is greater than 0.00 then display result.
I have tried this:
=IF(Sheet1!Q27>0,"")
but the result returns nothing.
any help is much appreciated.
KB

 

[nightcrawler23]

display what result?????????????????????????????

 

[prajul89]

What is the Result you want???

 

[nightcrawler23]

I think you want something like this,,,

=IF(Sheet1!Q27>0,"",Sheet1!Q27)

 

[karobonas]

What is the Result you want???

Sorry, the result I would like to display is the data that is contained within that cell.... i.e. 0.1

 

[karobonas]

I think you want something like this,,,

=IF(Sheet1!Q27>0,"",Sheet1!Q27)

Hi,

I have tried this though when I enter the formula and hit return it asks to direct towards a file??

 

[tc88]

Sorry, the result I would like to display is the data that is contained within that cell.... i.e. 0.1

Is the IF statement on Sheet1?

I think you have your arguments backwards:

=IF(Sheet1!Q27>0,Q27,"")

That says: if Sheet1 cell Q27 is greater than 0, display that value in Sheet 1 cell Q27, otherwise display blank.

 

[karobonas]

Is the IF statement on Sheet1?

I think you have your arguments backwards:

=IF(Sheet1!Q27>0,Q27,"")

That says: if Sheet1 cell Q27 is greater than 0, display that value in Sheet 1 cell Q27, otherwise display blank.

No the IF Statement is on Sheet 2, the data is in sheet 1... sorry for the confusion.

 

[tc88]

No the IF Statement is on Sheet 2, the data is in sheet 1... sorry for the confusion.

I would still try my formula, the formula that you have in your first post says:

If Sheet1!Q27 is greater than 0, return a blank (""), with no argument for "value_if_false"

 

[prajul89]

=IF(Sheet1!Q27>0,Sheet1!Q27,0)

See if this is what you want.