Returning Specific Cell Content using IF Statement

W

weeclaire

: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'!B22>0,-'Interest Fee Income'!B22,0)

Please help.

Claire
 
P

pinmaster

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

Regards
Jean-Gu
 
K

Kevin B

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'!A22>0,-'Interest Fee Income'!A22,0)

To this:

=IF('Interest Fee Income'!A22>0,'Interest Fee Income'!A22,0)
 
Top