Plz Help Microsoft Excel Novice

[hitec80]

Someone help me I’m a complete novice at Microsoft excel
Let’s imagine a betting scenario
a1 is the stake whilst b1 is the price/odds and so c1 =profit/winnings
C1=SUM(A1*B1)
Now a2 = 5 and b2= 4 ……. C2=SUM(A2*B2)
I only want to calculate c2 if c1 is a profit i.e. more than 0
If c1 is not more than 0 than I don’t want to calculate C2
How do I do this condition? ….. I’ve tried this by going to insert and
then function etc but it doesn’t work can you give me a step by step
guide on how to do this

 

[Beege]

hitec,
type in cell C1 =A2*B2 You don't need SUM here.
type in cell C2 =IF(C1>0,A2*B2,"")

Look in helpfile for "IF worksheet function for an explanation.

Beege

 

[Pete Gerhard]

Not sure I quite follow. What's the difference between C1 and C2??

You can use an IF statement like this in your field
"=(IF((A2*B2)>0,A2*B2,"")
This If statement tests to see if A2*B2 is >0. If it is, it performs the
first of two operations - sets field to A2*B2. If not, it gives a blank
field i.e. nothing between two quotes. You could put a zero there instead.

Hope this helps.

Pete

 

[BruceM]

Join Gamblers Anon if this pops up often!!! "GoingBroke!"
"=(IF((A2*B2)>0,A2*B2,"Going Broke!")