Previous Topic Next Topic

Please need answer fast

Closed
Sina - 16 Oct 2009 à 10:34
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 16 Oct 2009 à 21:58
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.

1 response

Réponse 1 / 1
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
16 Oct 2009 à 21:58
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)

Similar discussions

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

14 responses
WhatsApp Bluetooth calls issue
Sleek -
hransheed -

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

2 responses
forget my password and security question answer
ramson meshark -
Ramso -

4 responses
Gmail how do l get my secret question up
stegary -
xpcman -

1 response