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

 

[karobonas]

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

See if this is what you want.

It is still not working....

I have changed the name of Sheet 1 to 'SAL Forecast Effort' and Sheet 2 is now, 'August Projects'.

The data that I wish to display is in 'SAL Forecast Effort' and I wish to display this data in 'August Projects'. The data that is in 'SAL Forecast Effort' is defined by another formula that displays the result as a number between 0 and 1.00.

This is the formula I have placed into a cell in 'August Project':

=IF('SAL Forecast Effort'!Q27>0,"",'SAL Forecast Effort'!Q27)

This should work should it not? The data is defined by another formula, does this cause problems?

Sorry for not being clear.

 

[prajul89]

=IF('SAL Forecast Effort'!Q27>0,'SAL Forecast Effort'!Q27,0)


I am really confused what you required but hope this would do the job.

 

[karobonas]

=IF('SAL Forecast Effort'!Q27>0,'SAL Forecast Effort'!Q27,0)


I am really confused what you required but hope this would do the job.

Thank you,

this worked perfectly!