| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Plz Help Microsoft Excel Novice
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Plz Help Microsoft Excel Novice
This question appears to be coming up alot tonight, is the answer we gave you and hour ago not working for you??? Let us know so we can help, instead of repeating the question  -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=520388 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Installing: Microsoft Excel Feature | Excel Discussion (Misc queries) | |||
| Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet | Excel Discussion (Misc queries) | |||
| Microsoft Excel is waiting for another application to complete an OLE action | Excel Discussion (Misc queries) | |||
| Excel instance used with "Export to Microsoft Excel" option in Internet Explorer | Excel Discussion (Misc queries) | |||
| Create New Microsoft Excel Worksheet Has 3 Sheets | Setting up and Configuration of Excel | |||
Hybrid Mode
