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 rank...
As variant
=IF(Table5[@[Stock Required at ranked cover required]]>0, ROUND(Table5[@[Stock Required at ranked cover required]]*$AN$7, 0), 0)
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)- Many thanks for your help.
Malcolm McMaster , you are welcome