You can reference cells for brokerage like this:=IF(ISBLANK(E5)=TRUE,0,IF(F5="Open",IF(I5<1000,$E$19,$E$20),(IF(I5<1000,$E$19,$E$20)+IF(G5*L5<1000,$E$19,$E$20))))
Cheers
CC
You can reference cells for brokerage like this:=IF(ISBLANK(E5)=TRUE,0,IF(F5="Open",IF(I5<1000,$E$19,$E$20),(IF(I5<1000,$E$19,$E$20)+IF(G5*L5<1000,$E$19,$E$20))))
Cheers
CC
You’re viewing a single post only. To view the entire thread just sign in or Join Now (FREE)
