I am creating a basic formula to work out the $ value of a percentage of a invoice
The percentage is usually 10%, 5%, 2% or 0%.
The excel formula would normally be Value * % = % Value for example $1000 * 10% = $100
but in Infinity that formula doesn’t work BUT value ($) / Retention (%) = Retention Value does work.
But when I use Zero as the % value I get #Div/0! as the answer
What am I doing wrong ?