+ Reply to Thread
Results 1 to 2 of 2

Plz Help Microsoft Excel Novice

  1. #1
    hitec80
    Guest

    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


    --
    hitec80

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,486
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1