1. The forums are temporarily closed for new registrations
    We expect to re-open for new users towards the end of July.
    Dismiss Notice

Excel help

Discussion in 'SMB' started by dafunk2, Jul 12, 2019.

  1. dafunk2

    dafunk2 Midfield

    I've tried Google but can't seem to locate what I'm after.

    So I have a spreadsheet with numbers in columns C - G. I also have a number in column H. What I want is for Excel to multiply the highest number located in C - G by the number in column H. Any help would be massively appreciated!!
     
  2. Frijj

    Frijj Striker Contributor

    I’m sure there’s a function that pulls the highest number in a specified range.

    I’m heading into the office now so will check it out later but I’ll probably be solved by then.

    @Some Random Guy
     
  3. JDD

    JDD Full Back

    I think to get the max it'll be something like MAX(C:G) then just normal multiply maybe?

    Just guessing at the last bit but it'll be something along those lines
     
  4. zwartekat

    zwartekat Striker

    I think Max will find the highest number in a range but won't select it so probably no good for an onward calc. I'm no expert, mind.
     
    Some Random Guy likes this.
  5. =(MAX(C1:G1))*H1
    Assuming you just wanted it for each row you'll just copy the formula down.
     
    Frijj, zwartekat and Some Random Guy like this.
  6. girojim

    girojim Striker

    =H1*MAX(C1:G1)
     
  7. johnnyat87

    johnnyat87 Winger

    It will, just tested it.
    Spot on.
     
  8. Some Random Guy

    Some Random Guy Striker

    Jim & RN answered it.
     
    Last edited: Jul 12, 2019
  9. zwartekat

    zwartekat Striker

    Aye, keeping me trap shut in future and leave it to those who know. :lol:
     
  10. dafunk2

    dafunk2 Midfield

    Have tried that but it just comes back as 0?
     
  11. Some Random Guy

    Some Random Guy Striker

    You sure they are formatted as numbers?
     
  12. dafunk2

    dafunk2 Midfield

    Ignore me!!! I forgot to change the row number in the formula :oops:

    Cheers all!!
     

Share This Page