Probably did not head the subject correctly, but it makes sense to me... Here's the statement:
=IFERROR(IF(B27=((B32*B11)/B10),FALSE,IF(B27=((B32*B11)/B10),TRUE,IF(B27 =0,"0"))),"?") the statement B27=((B32*B11)/B10 will almost always end in a decimal therefore the statement will always say "False." What I would like to do is either roundup / down to the nearest whole number or maybe a tolerance "+ / - 10%" Is any of the thoughts I have possible? Thanks in advance. Denis -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
