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

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

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

3 responses
WhatsApp Bluetooth calls issue
Sleek -
hransheed -

8 responses
Fan runs so fast but cpu is not rebooting
Ai -
Johnny -

2 responses