Forum Discussion

Dmills958's avatar
Dmills958
Copper Contributor
Nov 30, 2020

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 ...
excel
mathetes's avatar
mathetes
Gold Contributor
Nov 30, 2020

Dmills958 

 

Would you be willing to post the actual spreadsheet? Otherwise you're asking us to recreate our own, which may or may not accurately represent yours. Doing so would make it easier for anybody here to help you.

  • mathetes's avatar
    mathetes
    Gold Contributor
    Nov 30, 2020

    Dmills958 

     

    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

Resources