Skip to content
  • Register
    • Advertisement
    If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
    Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
    Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
    If we do not hit our goal we will be forced to close the site.

    Current status: https://keepboardsalive.com/

    Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.

    Excel

    • 09-01-2017 08:12PM
      #1
      Green&Red
      Registered Users, Registered Users 2 Posts: 11,801
      ✭✭✭✭


      Guys, looking for some help writing an excel line.
      I want to say
      (A1*B1) [if C1 is greater than 2000] + (A2*B2) [if C2 is greater than 2000] (A3*B3) [if C3 is greater than 2000] etc

      Any help would be appreciated


    Welcome!

    It looks like you're new here. Sign in or register to get started.
    Sign In
    Register

    Comments

    • #2
      wijam
      Registered Users, Registered Users 2 Posts: 756 wijam
      ✭✭✭


      Hey Green, below is the formula in Excel 2016, note, I'm pretty sure in Excel in 2013 and earlier, you would use , instead of ; in the formula

      =IF(C1>=2000;A1*B1;0)+IF(C2>=2000;A2*B2;0)+IF(C3>=2000;A3*B3;0)


    • #3
      Green&Red
      Registered Users, Registered Users 2 Posts: 11,801 Green&Red
      ✭✭✭✭


      wijam wrote: »
      Hey Green, below is the formula in Excel 2016, note, I'm pretty sure in Excel in 2013 and earlier, you would use , instead of ; in the formula

      =IF(C1>=2000;A1*B1;0)+IF(C2>=2000;A2*B2;0)+IF(C3>=2000;A3*B3;0)

      Thanks Wijam
      One more question, how do I get this to cover a range, down to 100 say?
      Thanks a million, I appreciate it


    • #4
      wijam
      Registered Users, Registered Users 2 Posts: 756 wijam
      ✭✭✭


      Green, the easiest way would be to put a simple formula in column D, =IF(C1>=2000;A1*B1;0), copy it down the range and then sum Column D

      Not too sure about using an IF statement over the range, might be possible, but I wouldn't know it off the top of my head


    • #5
      mccy02
      Registered Users, Registered Users 2 Posts: 18 mccy02
      ✭


      Hi


      I have an excel problem and I hope someone can help me solve it. I have a Swift Excel file that I am uploading to Sharepoint, but it won't open in Sharepoint, and give me an error message saying that there are unsupported features, specifically:

      "Custom toolbar attached to the workbook (also called attached toolbar)"

      Can anyone tell me how I might resolve this in the file on my pc so that the uploaded file will open in Sharepoint please?

      Thanks!


    • #6
      igCorcaigh
      Moderators, Recreation & Hobbies Moderators Posts: 12,762 igCorcaigh
      Mod ✭✭✭✭


      mccy02 wrote: »
      Hi


      I have an excel problem and I hope someone can help me solve it. I have a Swift Excel file that I am uploading to Sharepoint, but it won't open in Sharepoint, and give me an error message saying that there are unsupported features, specifically:

      "Custom toolbar attached to the workbook (also called attached toolbar)"

      Can anyone tell me how I might resolve this in the file on my pc so that the uploaded file will open in Sharepoint please?

      Thanks!

      Can you just remove the custom toolbar?


    • Advertisement

    Welcome!

    It looks like you're new here. Sign in or register to get started.
    Sign In
    Register
    Advertisement