Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Error Message as test Criteria
If a formula returns a number or an error message how do I use the error message in a logical test. -- Taru ------------------------------------------------------------------------ Taru's Profile: http://www.excelforum.com/member.php...o&userid=35494 View this thread: http://www.excelforum.com/showthread...hreadid=552702 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Error Message as test Criteria
Here is a formula that with a Cell A2/B2. If there is an error (such as Div
0#) it inserts a blank, if there is no error it does shows the calculation. does that help? =IF(ISERR(A2/B2)=TRUE,"",A2/B2) "Taru" wrote: If a formula returns a number or an error message how do I use the error message in a logical test. -- Taru ------------------------------------------------------------------------ Taru's Profile: http://www.excelforum.com/member.php...o&userid=35494 View this thread: http://www.excelforum.com/showthread...hreadid=552702 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Error Message as test Criteria
Wow, I was just wondering how to do this and here's this posting. I am
working with a large spreadsheet which is downloaded each month. I've pasted my formula into an entire row and now want those cells with the error message to be blank. How do incorporate this into my formula, =LOOKUP(AA23,{0.12,0. 13,0.14,0.15,0.16,0.17,0.18,0.19,0.2,0.21,0.22,0.2 3,0.24,0.25},{".08",".10",". 10",".10",".105",".11",".11",".13",".13",".13",".1 4",".14",".14"})? Tim M wrote: Here is a formula that with a Cell A2/B2. If there is an error (such as Div 0#) it inserts a blank, if there is no error it does shows the calculation. does that help? =IF(ISERR(A2/B2)=TRUE,"",A2/B2) If a formula returns a number or an error message how do I use the error message in a logical test. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200606/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DAVERAGE criteria HELP!!!! | Excel Discussion (Misc queries) | |||
results of "SUMIF" test criteria | Excel Worksheet Functions | |||
Returning Results Based on Two Criteria | Excel Worksheet Functions | |||
sorting more than 3 keys | Excel Discussion (Misc queries) | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions |