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
=IF($AB15=”rolled-in”,+$X15/2-$AD15+AD15,IF($AB15=”actual invoiced”,+$X15/2+$AD15,IF($AB15=”none (virtual)”,+$X15/2,0)))
Basically I need x minus y = the total divided by 2 + y then the total divided by 2 (this is the whole formula but it will be broken up into 2 different columns
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 =IF($AB15=”rolled-in”,+$X15/2-$AD15+AD15,IF($AB15=”actual invoiced”,+$X15/2+$AD15,IF($AB15=”none (virtual)”,+$X15/2,0))) Basically I need x minus y = the total divided by 2 + y then the total divided by 2 (this is the whole formula but it will be broken up into 2 different columns Read More