Previous Topic Next Topic

Please need answer fast

Closed
Sina - Oct 16, 2009 at 10:34 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 16, 2009 at 09:58 PM
Hello,

I will try to explain .

i am looking fo a formula which calculates
B1=Sum(A1+A2 , but if A3 has a number then it schould be B1=SUM(A2+A3) instead)

Right now I have two colums with 2 calculations and if one is true then I use conditional formatting to hide the other calculation which leaves me with a big black coloum on the sheet.
Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 16, 2009 at 09:58 PM
your requirement is not clear particularly your second para about conditional formatting, the reason for which is not understood. however you try ths formula

=IF(A3="",A1+A2,A2+A3)
0

Similar discussions

WhatsApp Bluetooth calls issue
Sleek -
hransheed -

8 responses
Message not delivered but phone says ringing?
Ac2271 -
ravida_1351 -

2 responses
PC wont turn on. Fans spin loud.
juancrg -
Ififkfk -

14 responses
pc won’t display but fan runs loud
eddie -
jimmywick -

3 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses