Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
I have a bunch of if formulas in a column that read if the condition is true
then .25 if its false then "n/a". Is there a way for me to enter in a formula at the end of this column that reads all these formulas and says if any of them is "N/A" then "Error" if not sum them all up? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
Look into isna it returns whether a cell contains that error. It might be
best to put into each formula to ensure they are all numbers if applicable, just a quick example =IF(ISNA(B6),0,B6) -- -- -John Please rate when your question is answered to help us and others know what is helpful. "ynissel" wrote in message ... I have a bunch of if formulas in a column that read if the condition is true then .25 if its false then "n/a". Is there a way for me to enter in a formula at the end of this column that reads all these formulas and says if any of them is "N/A" then "Error" if not sum them all up? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
=if(isna(range of cells),Error,sum(range))
"ynissel" wrote: I have a bunch of if formulas in a column that read if the condition is true then .25 if its false then "n/a". Is there a way for me to enter in a formula at the end of this column that reads all these formulas and says if any of them is "N/A" then "Error" if not sum them all up? Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
its not an NA error its like this if(a1=10,5,"N/A")
So the N/A is text that is an answer of the if statement. The ISNA seems to only work if the result of the formula is an NA error. Am I making sense? Is there a way around this? Thanks "Sean Timmons" wrote: =if(isna(range of cells),Error,sum(range)) "ynissel" wrote: I have a bunch of if formulas in a column that read if the condition is true then .25 if its false then "n/a". Is there a way for me to enter in a formula at the end of this column that reads all these formulas and says if any of them is "N/A" then "Error" if not sum them all up? Thanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
I just figured it out - I did an array
=if(sum(if(a1:a20="N/A",1,0)0,"Error",sum(a1:a20)) Thanks!! "Sean Timmons" wrote: =if(isna(range of cells),Error,sum(range)) "ynissel" wrote: I have a bunch of if formulas in a column that read if the condition is true then .25 if its false then "n/a". Is there a way for me to enter in a formula at the end of this column that reads all these formulas and says if any of them is "N/A" then "Error" if not sum them all up? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula question | Excel Worksheet Functions | |||
Repeating Formula Question | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |