LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 3
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Installing: Microsoft Excel Feature Boblink Excel Discussion (Misc queries) 0 May 13th 05 05:41 PM
Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet Graham Jones Excel Discussion (Misc queries) 1 May 13th 05 12:58 AM
Microsoft Excel is waiting for another application to complete an OLE action Glen Davis Jr. Excel Discussion (Misc queries) 0 May 4th 05 04:10 PM
Excel instance used with "Export to Microsoft Excel" option in Internet Explorer Karl Schweitzer Excel Discussion (Misc queries) 0 April 7th 05 06:17 PM
Create New Microsoft Excel Worksheet Has 3 Sheets Bassam Setting up and Configuration of Excel 0 February 9th 05 08:51 PM


All times are GMT +1. The time now is 08:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"