I need to add another condition to a formula and can't seem to get it to work correctly.
Could someone please tell me the correct way to add:
If #NUM! shows up to display "0"
to
=MEDIAN(IF((Z:Z=AT17)*(Y:Y="TRANS")*(AD:AD<>"LEAP"),AE:AE))
Thank you very much!
Last edited by KINNEY0201; 10-04-2010 at 04:13 PM.
With XL 2007 you can use =IFERROR(your formula, 0)
Never use Merged Cells in Excel
And if you need to be backward compatable, say a client/co-worker uses 2003
IF(ISERROR(your formula),0,your formula)
Perfect! Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks