Can anyone see what the problem with this formula might be? The formula
refers to a checkbox value on another sheet (Commission Pool) and a value
from even another sheet (Commission Level) all to go into the
selected/current sheet (Leasing_1)

=IF('Commission Pool'!CheckBox.1.value=TRUE,'Commission Level'!I18,"")

--
Randy Street
Rancho Cucamonga, CA