Thread
:
Calculation within IF function
View Single Post
#
2
cmart02
Posts: n/a
Wrap the calculatioin with the function ROUND in order to get the precision
you need:
ROUND(5625*0.07-393.75,0)=0
If you type =5625*0.07-393.75=0 in a cell Excel returns FALSE, thus, causing
the problem you're encoutering.
Regards,
Robert
Reply With Quote