ok, excel boffins at the ready

taskey
taskey Registered Posts: 1,800 Beyond epic contributor 🧙‍♂️
right please bear with me on this, i am good on excel, but this is maybe beyond me

i have a table with standard charges on it. i want to enter a letter for the charge and it will automatically pick up the amount and change it for me. i also want it to work out if i change the number of days to be below 15 it does not charge - mmmm. stumped!!

the data to be picked up is on another sheet within the same book.

i can email to someone if they want to have a look at it for me, i cant attach it for some reason.

might be something really silly i am over looking.

thanks in advance

Tracy

Comments

  • slackda
    slackda Registered Posts: 460 Dedicated contributor 🦉
    sent you a pm drop me an email with the details.
  • PGM
    PGM Registered Posts: 1,954 Beyond epic contributor 🧙‍♂️
    I'd use the sumif function, its handy I use it for all sorts of things.
  • taskey
    taskey Registered Posts: 1,800 Beyond epic contributor 🧙‍♂️
    i have emailed it over to slakda, i have tried all sorts, it is probably staring at me in the face

    we will see

    thanks

    Tracy
  • slackda
    slackda Registered Posts: 460 Dedicated contributor 🦉
    done me thinks, Some multple if statements with vlookups tied into the equations should have sorted it.


    Oh and sumif is the best function eva!
  • taskey
    taskey Registered Posts: 1,800 Beyond epic contributor 🧙‍♂️
    i knew someone would resuce me from my misery lol

    Thanks again

    Tracy
Privacy Policy