Forum Discussion
HELP ASAP with Formula please
I feel like I'm so very close but keep getting an error. Basically, the error is in the 1st part of the formula below in red. What I added the /2 and then added the AD15 at the end i get the error ...
It seems like there is a redundancy in the formula where you add AD15 and subtract AD15. This could be the cause of the error, without being sure if it actually is.
=IF($AB15="rolled-in", $X15/2 - $AD15, IF($AB15="actual invoiced", $X15/2 + $AD15, IF($AB15="none (virtual)", $X15/2, 0)))