Hi everyone,

Please could you help me with the following problem I am having with calculating a database.

I have a database of numbers

Product / Units / Profit Margin

Prod A 1 100
Prod B 2 200
Prod C 0 100

To calculate how much profit per piece I can insert a basic sum Profit Margin / Units - However I would like to also see if there is a 0 how much the profit margin should be - So it should be =IF(=>1,Profit Margin/Units),(<0,=Profit Margin)

Does anyone know which function I could use to help to get to calculate this please?