Advertisement
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.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

Excel

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


    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


Comments

  • #2
    wijam
    Registered Users, Registered Users 2 Posts: 759 ✭✭✭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,862 ✭✭✭✭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: 759 ✭✭✭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, Paid Member Posts: 12,951 Mod ✭✭✭✭igCorcaigh


    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
Advertisement