Will something like this work?
=IF(AND(A1=1,A1<=12),B1*C1+135,"")
--
Hope this helps,
MarkN


"bluesky" wrote:

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