Excel spreadsheet

[Closed]
Report
-
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
-
Hello,

I would like a cell to contain the sum of one row, but if the second row has figures entered i would like it to show that; e.g.

Q8 has 20.00
Q9 is blank
so cell S8 has 20.00

Q8 has 20.00
Q9 has 21.00
So i want S8 to say 21.00

Thanx


1 reply

Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
Hope I'm not too late:
In cell S8 put in:
=IF(Q8<>"",IF(Q9<>"",Q9,IF(Q9="",Q8)))