Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Excel Function Help.

  • 06-04-2006 05:04PM
    #1
    Raskolnikov
    Registered Users, Registered Users 2 Posts: 10,148 ✭✭✭✭


    I have a spreadsheet that I'm currently using to manage my betting habit. Instead of making the calculations manually and filling them in, I want to try and automate everything. I have three columns that need working on, column D has the odds that I'm betting on, column E has the stakes, column F is going to be a boolean value (Y or N) that I enter, to signify a sucessful or failed bet. What I want to happen is that if I enter a Y in a row in column F, then I want the product of D and E entered into the column next to it. If I enter a N, then I want the stake (the value in column E) to be entered into column next to it.

    Is this, or something like it possible?


Comments

  • #2
    frost
    Registered Users, Registered Users 2 Posts: 249 ✭✭frost


    Yes, just use a pair of IF() functions: 
    In  column G:
=IF(F2="Y",D2*E2,0)

In column H:
=IF(F2="Y",0,E2)


Advertisement