|
If you wish to
have a function return a blank value (not zero) to the cell, use quote marks without a space between them. Here’s an example:
=IF(E6>=Quota,E6*Comm_Rate,"")
This formula example calculates, or returns, a
commission value to the cell containing the formula if the test is true. If the test is false, it returns an empty string (a blank value) to that cell.
Hope this helps
__________________
ICQ-46523581
|