Forum Discussion

CEG916's avatar
CEG916
Copper Contributor
Apr 24, 2024

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

  • MAngosto's avatar
    MAngosto
    Iron Contributor

    CEG916 

     

    Hi, could you elaborate further this with you actual cell references: "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 recommend that you use parenthesis in your formulation/explanation. You could also help us help you by attaching a screenshot or a sample document without sensitive data.

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    CEG916 

    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)))

Resources