formulas for excel

  steves100 18:56 30 Oct 2005
Locked

Formulas for excel
I’m not sure this is the best forum for my question!
But here goes. I’m have problems with creating a formula to return a numeric code for a letter i.e. say Holiday =H = 8hours so if there is say five H’s in one row then the total would return a value of 40 . Has anyone got any ideas please.
Stevie.

  Forum Editor 19:20 30 Oct 2005

instead of the Helproom - I'll move your thread there now, and you'll soon have your answer.

  VoG II 19:24 30 Oct 2005

=COUNTIF(A1:J1,"H")*8

  steves100 19:33 30 Oct 2005

Thanks VoG i got a bit bogged down there it was the 'IF' Part i totaly forgot about thanks again.
Stevie.

  Forum Editor 19:57 30 Oct 2005

4 minutes - not bad, eh?

  stalion 19:58 30 Oct 2005

bit slow for VoG™ lol

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iMac Pro review

3D illustrator Billelis on how to promote yourself on social media

iMac Pro review

Apple Music : comment obtenir 3 mois gratuits ?