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
Spreadsheet Help, page-12
-
- There are more pages in this discussion • 3 more messages in this thread...
You’re viewing a single post only. To view the entire thread just sign in or Join Now (FREE)
