formulas for excel

  steves100 18:56 30 Oct 05
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 05

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

  VoG II 19:24 30 Oct 05

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

  steves100 19:33 30 Oct 05

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 05

4 minutes - not bad, eh?

  stalion 19:58 30 Oct 05

bit slow for VoG™ lol

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

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Best Design, Illustration, Animation and VFX Awards of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced