I have this formula in a cell but dont want it to add the Salaries if one or both of 2 other fileds are empty.
=SUM(D3546)+Salaries!C5+Salaries!C6
Salaries!C5 needs to be added only if cell D34 has a value
Salaries!C6 needs to be added only if cell D47 has a value
I cant figure out how the statement would be, any help would be appreciated...
=SUM(D3546)+Salaries!C5+Salaries!C6
Salaries!C5 needs to be added only if cell D34 has a value
Salaries!C6 needs to be added only if cell D47 has a value
I cant figure out how the statement would be, any help would be appreciated...