Forum Discussion
I have a long IF statement and need to return blank so I can use those cells for another statement
E F G H I J K Win 0.5 -130 0.38 $1.38 Win 0.5 -145 0.34 ...
I took the version that SergeiBaklan had given you and added another useful feature, one that makes your formulas a bit shorter AND easier to read. That's a feature that's called a "Named Range."
Where you were referring to 'Totals Hidden'!$C$3 in your formulas, I named the value in that cell as BetUAmnt, so now a formula using it looks like this:
=IF(G2>1,BetUAmnt*'Unit money'!F2*('Unit money'!G2/100), BetUAmnt*F2/(-G2/100))
Similarly, I took your references to 'Totals Hidden'!$C$8 and replaced them with StrtBnkrll so the one formula that refers to cell C8 now reads:
=StrtBnkrll+'Unit money'!J2