I have the following:

D47=IF(D45="","",ROUND(D45+D46,2))
F47=IF(F45="","",ROUND(F45+F46,2))

But I also need D47=If(D46="","",Round(D45+D46,2)) and the same with F47. (if either D45 or D46 have a number I need a resulting sum.

If D47 or F47 have a value I want to sum these in E48 if not I want to return "".

Its been a while since I used if/and/or strings and need your help.

TIA

ETA:

Solved my first half by using
=if(and(d45="",d46=""),"",D45+D46)
and the same for F column

I tried using the same equation for E48 but get "#Value" if I dont have a value in either of the two previous equations.

Suggestions.
ETA2

=IF(AND(D47="",F47=""),"",D47+F47)
This gives me a blank cell as I would like with no info in the other 4 cells and I get the desired result with info in one cell from both columns but not one cell in one column.

This post was edited on 11/16/16 at 2:01 am

3 ...

Report Post

Posted by Bullfrog

Institutionalized but Unevaluated

Member since Jul 2010

56150 posts

Posted on 11/16/16 at 1:56 am to Geaux-2-L-O-Miss

Maybe:

IF(D45>0,ROUND(D45+D46,2),IF(D46>0,ROUND(D45+D46,2),"")

0 ...

Report Post

Posted by seawolf06

Member since Oct 2007

8159 posts

Posted on 11/16/16 at 8:03 am to Geaux-2-L-O-Miss

How is your data arranged?

If you are trying to add a number and a formula, even if the return is "", it will give you a #VALUE error. There are a few ways that you could get around this.

=IF(OR(AND(D47="",F47=""),ISERROR(D47+F47)),"",D47+F47)

However, if you want to return a value for the number plus the blank (i.e. 7 + "" = 7), then you probably need to arrange your data differently or use a different method.

This post was edited on 11/16/16 at 8:06 am

0 ...

Report Post

Posted by mdomingue

Lafayette, LA

Member since Nov 2010

29970 posts

Posted on 11/16/16 at 12:47 pm to Geaux-2-L-O-Miss

Try the SumIf() function.

Ex. = SUMIF(D45:D48,">0") + SUMIF(D45:D48,"<0")

What this will do is if any value is a number in the range it will add it unless it's 0 which is 0 so no harm, no foul there.
ETA: That will get you the numerical results you want but not blank cell otherwise. If you are certain that your data will never sum up to zero you could just do this
=IF((SUMIF(B3:B10,"<0")+SUMIF(B3:B10,">0"))=0,"",SUMIF(B3:B10,"<0")+SUMIF(B3:B10,">0"))

This post was edited on 11/16/16 at 1:03 pm

Page 1