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

Fujitsu Lifebook P727 laptop review

Microsoft Paint set to die after 32 years

Mac power user tips and hidden tricks

Comment désactiver la saisie intuitive et paramétrer votre clavier ?