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
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.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Try this...
Formula:
=IF(AND($E11>30,$E11<=60),F11,0)
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
cool it works.. thanks benishiryo andSixthsense
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks