Thread: excel formular
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bluesky
 
Posts: n/a
Default excel formular

i need a formular that adds on 135 to an multiplacation if there is any
number between 1 and 12 in a certain cell but still lets the multiplication
work if there is no number or 0 in the cell everything i have tried so far
comes up with #DIV/0!

eg (b12 * b13) + 135 if a16 = 1 - 12

any help would be excellent asap please email to