ok, excel boffins at the ready

taskey

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

slackda

sent you a pm drop me an email with the details.

PGM

I'd use the sumif function, its handy I use it for all sorts of things.

taskey

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

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

i knew someone would resuce me from my misery lol

Thanks again

Tracy