ExcelBanter - excel formular

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - excel formular (https://www.excelbanter.com/excel-worksheet-functions/81289-excel-formular.html)

bluesky

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

MarkN

excel formular

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

All times are GMT +1. The time now is 11:11 AM.