Formula must produce two positive numbers otherwise an error message

[someguy4321]

Hi there,

I want to create a spreadsheet where:

1. Odds -- I enter two lots of 'odds' (can be any odds e.g. odds # 1 $1.50, odds # 2 $2.00)
2. I want the formula to work out how much money is required to back both odds (e.g. formula works out how much money I must back both odds to make a profit, i.e. 'total money won' minus 'total money down' and if both 'win amounts' are 'positive numbers' (not negative numbers) it means I make profit from backing both bets with the money down the formula has produced).

If there is a negative number in 1 or more 'win amounts' # 1 or win amount # 2 that means my bet fails and the formula displays 'Error - bet failed'. The formula must produce positive numbers for both bets for a successful bet. (i.e total winnings from both bets must be more than money down for bets # 1 and bets # 2.

Please see pic for clarification.

I hope it's not too confusing.

Thanks

Simon

[mick0005]

I don't know if I am oversimplifying this, but is this what you want?

Replace the text in red with your corresponding formulas u have already written for your bet results.

Win amount #1 =IF(OR(YOUR FORMULA FOR WIN AMOUNT 1<0,YOUR FORMULA FOR WIN AMOUNT 2<0),"Error - Bet Failed",YOUR FORMULA FOR WIN AMOUNT 1)

Win amount #2 =IF(OR(YOUR FORMULA FOR WIN AMOUNT 1<0,YOUR FORMULA FOR WIN AMOUNT 2<0),"Error - Bet Failed",YOUR FORMULA FOR WIN AMOUNT 2)

[someguy4321]

That is close to what I wanted.

Replace the text in red with your corresponding formulas u have already written for your bet results.

I don't have formulas written for my bet results. I want Excel to calculate mathematically and find out the 2 bet amounts which will create 2 positive numbers (i.e. 2 positive numbers being win amount # 1 and win amount # 2).