Thread: Formulas
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jim7_mbay Jim7_mbay is offline
external usenet poster
 
Posts: 1
Default Formulas

=sum(a1:b1) and then copy and paste. Copy and paste it .the best orthodox way.

"Tom Ogilvy" wrote:

=if(A130,A1+B1,B1)
--
Regards,
Tom Ogilvy

"GBH99" wrote in message
...
If column A is 30 and column B is 50, I need a formula that will only

print
the 50, but if column A is any figure abouve 30 I need the formula to add
column A + B together. Can anyone help please.