If Function - Return value 0 when referenced cell is also 0

[fleyd]

Hi,

I have the following formula:

=IF(AND(T7>0,T7<=1),($J$2+0,05),IF(T7>1, $J$2,IF(T7=0,"0")))

But i need that when T7=0 , the result of the formula be 0 (zero). Currently the result is value of cell $J$2 (0,08).

I add the information that cell T7 is a reference from another sheet in the same document, not sure is this changes things...


Can you help me in a way that the result of the formula be 0 when t7 is also 0 ?

Thanks

[mehmetcik]

Please Login or Register  to view this content.

[fleyd]

Thanks, but it doesnt work... the problem is that cell t7 is not really 0, its a referenced cell... the issue is that...

i send an example file https://dl.dropboxusercontent.com/u/...0question.xlsx

can you help with another solution?

[newdoverman]

Answer to your first problem:

Please Login or Register  to view this content.

If T7 results in an error, or if T7 is equal to 0 the result will be 0.

[FDibbins]

fleyd, please upload your file to the forum, not all members are able - or willing - to access file hosting sites

[fleyd]

Hi,

Sorry for the late reply and many thanks for the solutions, it worked!!


1 - Just a little detail, i use Portuguese version of Excel and for the formula really work, i had to slighlty change it to this:

=IFERROR(IF(T7="0",0,IF(AND(T7>0,T7<=1),$J$2+0,05,$J$2)),0)

But is working just fine, many thanks for the Help!

2 - Regarding adding the file here in the thread, i didnt do it because i didnt understand how to do it, just now i realize i had to go advanced options, sorry about that. But i think its all correct now.

Thanks.