if formula returns ":false" instead of "0"

**pja_14** · 05-20-2013, 03:30 AM

Hi,

Good day. I'm making if formula for my accounts receivable aging, my formula for 30-60 days shows like this =if(e11>30, if(e11<=60, f11,0)). it will capture the amount in f11 if it is within the formula but returns false instead of 0 if not.

Hope you could help me on this one.

Thanks

Paul

**benishiryo** · 05-20-2013, 03:40 AM

hi Paul, welcome to the forum. maybe:
=IF(AND(E11>30,E11<=60),F11,0)

your formula would fail at the first test if it's less than or equals to 30. hence it will return FALSE.

**:) Sixthsense :)** · 05-20-2013, 03:41 AM

Try this...

Formula:

Please Login or Register  to view this content.

**pja_14** · 05-20-2013, 04:09 AM

cool it works.. thanks benishiryo and

Sixthsense

if formula returns ":false" instead of "0"

LinkBack

Thread Tools

Rate This Thread

Display

if formula returns ":false" instead of "0"

Re: if formula returns ":false" instead of "0"

Re: if formula returns ":false" instead of "0"

Re: if formula returns ":false" instead of "0"

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions