Rich Text Formulas Using Numeric Ifs
Hi Let me first start with thanks to everyone who posts in these forums I have learned so much from you. I do NOT code but I am real good a trial and error also google. So you have been a life saver. ...
Forum Discussion
So Rounding the whole argument totally worked!!!! Thank you. That was actually one of my early thoughts so I added a .01 round to the formula in [Final Sale Price] and made sure the PO fields were currency 2 decimal places and treated blanks as Zero, which as I type this may be the issue. Since some are blank it might have tried 0 NOT 0.00. Either way it works now so thanks!