Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Error Messages
i have a cell that draws information from the sheets that have not been
filled in yet and i recive #N/A i would like to recive nothing in that cell. =SUM(Q39*144/V39) In a nother sell i recive #DIV/0! The formula is =((0.109136*(Q39^1.9))/R39)^(1/5.02) if the imformation is not avalible would like it blank any help with this would be great |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Error Messages
Use ISERROR formula within IF
eg. =IF(ISERROR(B1/C1),"",B1/C1) general forms is =IF(ISERROR(your formula),"Result if formula gives error",your formula) "msao" wrote: i have a cell that draws information from the sheets that have not been filled in yet and i recive #N/A i would like to recive nothing in that cell. =SUM(Q39*144/V39) In a nother sell i recive #DIV/0! The formula is =((0.109136*(Q39^1.9))/R39)^(1/5.02) if the imformation is not avalible would like it blank any help with this would be great |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Error Messages
I don't understand what you are trying to do with =SUM(Q39*144/V39)
What do you want the SUM function to add to Q39*144/V39 ? Or did you intend your formula to be just =Q39*144/V39 ? If you need help on what the SUM function in Excel does, look up SUM in Excel help. If you want the result to be blank if V39 is blank, try =IF(V39="","",Q39*144/V39) If you want it to be blank if either V39 or Q39 is blank, try =IF(COUNT(V39,Q39)=2,Q39*144/V39,"") -- David Biddulph "msao" wrote in message ... i have a cell that draws information from the sheets that have not been filled in yet and i recive #N/A i would like to recive nothing in that cell. =SUM(Q39*144/V39) In a nother sell i recive #DIV/0! The formula is =((0.109136*(Q39^1.9))/R39)^(1/5.02) if the imformation is not avalible would like it blank any help with this would be great |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Error Messages
If V39 will always have numerics then
=IF(V39,Q39*144/V39,"") 'if V39 can contain text and numerics then =IF(AND(ISNUMBER(V39),V390),Q39*144/V39,"") same with R39 If this post helps click Yes --------------- Jacob Skaria "msao" wrote: i have a cell that draws information from the sheets that have not been filled in yet and i recive #N/A i would like to recive nothing in that cell. =SUM(Q39*144/V39) In a nother sell i recive #DIV/0! The formula is =((0.109136*(Q39^1.9))/R39)^(1/5.02) if the imformation is not avalible would like it blank any help with this would be great |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Error Messages
it is u39 that will recive the sum changed it to the fist one below would not
work "Jacob Skaria" wrote: If V39 will always have numerics then =IF(V39,Q39*144/V39,"") 'if V39 can contain text and numerics then =IF(AND(ISNUMBER(V39),V390),Q39*144/V39,"") same with R39 If this post helps click Yes --------------- Jacob Skaria "msao" wrote: i have a cell that draws information from the sheets that have not been filled in yet and i recive #N/A i would like to recive nothing in that cell. =SUM(Q39*144/V39) In a nother sell i recive #DIV/0! The formula is =((0.109136*(Q39^1.9))/R39)^(1/5.02) if the imformation is not avalible would like it blank any help with this would be great |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error messages | Excel Discussion (Misc queries) | |||
Name error messages... | Excel Worksheet Functions | |||
Error Messages | Excel Discussion (Misc queries) | |||
error messages | Excel Discussion (Misc queries) | |||
Error Messages | Excel Worksheet Functions |