SubTotal should be 5% greater than Total

[SBBmaster09]

What should be the formula where I need to get the gap between SubTotal and Total, where the SubTotal need to be more than 5% of the Total and must display true and if not false.

SubTotal and Total are calculated values.

[Kaper]

Please Login or Register  to view this content.

shall be enough. Of course instead of subtotala and total you could use addresses of cells where these values are calculated

[TMS]

Maybe:

Please Login or Register  to view this content.

formatted as a percentage for the value.

And:

Please Login or Register  to view this content.

for the TRUE/FALSE