Returning Specific Cell Content using IF Statement
 

:confused:

Hi Guys

I am trying to write an IF statement whereby if the statement is true
the return value is a specified tab and cell.

My current statement reads:

=IF('Interest Fee Income'!B220,-'Interest Fee Income'!B22,0)

Please help.

Claire


--
weeclaire
------------------------------------------------------------------------
weeclaire's Profile: http://www.excelforum.com/member.php...o&userid=28738
View this thread: http://www.excelforum.com/showthread...hreadid=513544

Returning Specific Cell Content using IF Statement
 

There's nothing wrong with your formula, it should return 'Interest Fee
Income'!B22 if it is 0, in a negetive format. What cell are you trying
to return?

Regards
Jean-Guy


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=513544

Returning Specific Cell Content using IF Statement
 

Your IF statement works fine, unless your not wanting a negative result. If
that's the case, remove that pesky minues "-" sign that prefaces you TRUE
statement.

Change this:

=IF('Interest Fee Income'!A220,-'Interest Fee Income'!A22,0)

To this:

=IF('Interest Fee Income'!A220,'Interest Fee Income'!A22,0)
--
Kevin Backmann


"weeclaire" wrote:


:confused:

Hi Guys

I am trying to write an IF statement whereby if the statement is true
the return value is a specified tab and cell.

My current statement reads:

=IF('Interest Fee Income'!B220,-'Interest Fee Income'!B22,0)

Please help.

Claire


--
weeclaire
------------------------------------------------------------------------
weeclaire's Profile: http://www.excelforum.com/member.php...o&userid=28738
View this thread: http://www.excelforum.com/showthread...hreadid=513544