Forum Discussion

Nicola Martin's avatar
Nicola Martin
Copper Contributor
Jun 04, 2018

IF Function - Returning Incorrect Result

 I want to understand why the formula result for this IF Function is different than the True Result by $1. You can see the calculated result as $3002.42 but the result returned as shown in the Formula Result is $1 higher at $3003.42

 

Many thanks

Formulas & Functions
Need Help
  • IngeborgHawighorst's avatar
    IngeborgHawighorst
    MVP
    Jun 05, 2018

    Hello,

     

    can you remove anything from the file that is not related to the problem and post the file for inspection? 

     

    cheers, teylyn

Resources