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?
Bookmarks