View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default NEED HELP WITH A FORMULA PROBLEM

=IF(B20,IF(C20,IF(B50,IF(C50,B2+B5,""),""),"") ,"")

"al619" wrote:

A B C
1 13 21
2 23 13
3 13
4 4 32
5 14 15

Please help with this formula. Example: B2 & C2 both have numbers and also
Columns B5 & C5. Since both of these columns have #'s in them I would like
B2&B5 to add together in a different column.

Thank you for any input,
al619