Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
div/0 and #num!
I have a column of data which is calculated based on the column adjacent to
it. I want to create an IF statement that will check to see if the number in the column is div/0 or #num! and if it is, display the value above it instead of trying to calculate something. ex a b c d 1 1 4 2 4 7 3 6 9 4 #num! 9*** this forumla doesn't seem to work =if(a4=#num!,b3,a4+3) how do i say the logical statement a4=#num! or div/0? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
div/0 and #num!
"bastien86" wrote: I have a column of data which is calculated based on the column adjacent to it. I want to create an IF statement that will check to see if the number in the column is div/0 or #num! and if it is, display the value above it instead of trying to calculate something. ex a b c d 1 1 4 2 4 7 3 6 9 4 #num! 9*** this forumla doesn't seem to work =if(a4=#num!,b3,a4+3) how do i say the logical statement a4=#num! or div/0? i'd really like an if statemet that says =if(a4=(#num! OR div/0!),=a3,a4+3) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
div/0 and #num!
Sorry i'm new to this board
i'd really like an if statemet that says =if(a4=(#num! OR div/0!),=a3,a4+3) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
div/0 and #num!
Perhaps if it is only an error you are interested in try iserror(a4) eg if(iserror(a4),b3,a4+3) This also traps some other errors, but that should not be a problem to you I imagine Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=551881 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
div/0 and #num!
Posting the same request 3 times in 6 minutes won't get you a quicker
response! Try this: =IF(OR(ERROR.TYPE(A4)=2,ERROR.TYPE(A4)=6),B3,A4+3) See ERROR.TYPE in Excel Help for an explanation. -- Ian -- "bastien86" wrote in message ... Sorry i'm new to this board i'd really like an if statemet that says =if(a4=(#num! OR div/0!),=a3,a4+3) |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
div/0 and #num!
PERFECT! thanks man
"Dav" wrote: Perhaps if it is only an error you are interested in try iserror(a4) eg if(iserror(a4),b3,a4+3) This also traps some other errors, but that should not be a problem to you I imagine Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=551881 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|