Search : in
By :

Please need answer fast

Last answer on Oct 17, 2009 2:58:21 am BST Sina, on Oct 16, 2009 3:34:27 pm BST 
 Report this message to moderators

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.

Configuration: Windows XP
Safari 532.0

Ask your question Reply

1

 venkat1926, on Oct 17, 2009 2:58:21 am BST

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)

   
Reply to venkat1926
Ask your question Reply
They need your help