Forum Discussion
Solved
Excel Formula
I have the following formula calculating a value & I need the result rounded to a whole number (ie, ignoring values of less that 1. Any help would be appreciated.
=IF(Table5[@[Stock Required at ranked cover required]]>0,Table5[@[Stock Required at ranked cover required]]*$AN$7,0)
As variant
=IF(Table5[@[Stock Required at ranked cover required]]>0, ROUND(Table5[@[Stock Required at ranked cover required]]*$AN$7, 0), 0)
5 Replies
You may wrap result by ROUND function - Microsoft Support
- Thanks Sergel, I understand this can be done, just dont know where to place the rounding & how to add it to the existing formula.
As variant
=IF(Table5[@[Stock Required at ranked cover required]]>0, ROUND(Table5[@[Stock Required at ranked cover required]]*$AN$7, 0), 0)
