| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ERROR.TYPE formula problem
I am trying to create a formula which will leave a cell empty if it's dividing by zero, or give me a result if there are numbers in the referenced cells. It seems simple enough, but I can't get it to work. My formula looks like this: =IF(ERROR.TYPE(E13/E2)0,"DUD",E13/E2) If there are no numbers in E13 and/or E2 it returns DUD, but if I put a number into either or both of E13 and E2, I get a #N/A error. I have tried formatting the cells specifically as numbers and as general but this hasn't made any difference. HELP!!!  Trish -- tuph ------------------------------------------------------------------------ tuph's Profile: http://www.excelforum.com/member.php...o&userid=31390 View this thread: http://www.excelforum.com/showthread...hreadid=544947 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ERROR.TYPE formula problem
Hi!
Just test for 0: =IF(E2=0,"",E13/E2) Biff "tuph" wrote in message ... I am trying to create a formula which will leave a cell empty if it's dividing by zero, or give me a result if there are numbers in the referenced cells. It seems simple enough, but I can't get it to work. My formula looks like this: =IF(ERROR.TYPE(E13/E2)0,"DUD",E13/E2) If there are no numbers in E13 and/or E2 it returns DUD, but if I put a number into either or both of E13 and E2, I get a #N/A error. I have tried formatting the cells specifically as numbers and as general but this hasn't made any difference. HELP!!! Trish -- tuph ------------------------------------------------------------------------ tuph's Profile: http://www.excelforum.com/member.php...o&userid=31390 View this thread: http://www.excelforum.com/showthread...hreadid=544947 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ERROR.TYPE formula problem
Thanks, Biff! I knew it had to be simple  -- tuph ------------------------------------------------------------------------ tuph's Profile: http://www.excelforum.com/member.php...o&userid=31390 View this thread: http://www.excelforum.com/showthread...hreadid=544947 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ERROR.TYPE formula problem
You're welcome!
Biff "tuph" wrote in message ... Thanks, Biff! I knew it had to be simple -- tuph ------------------------------------------------------------------------ tuph's Profile: http://www.excelforum.com/member.php...o&userid=31390 View this thread: http://www.excelforum.com/showthread...hreadid=544947 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula percentage problem | New Users to Excel | |||
| formula problem | New Users to Excel | |||
| problem with Array Formula | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Baffling formula problem | Excel Discussion (Misc queries) | |||
Linear Mode
