formula help

  • Thread starter Thread starter Cheryl
  • Start date Start date
C

Cheryl

Is the following even possible?
Cell B5 = OT2 and cell C5 = OT4....can the formula total B5 & C5 as
OT=6 OR SAY
Cell E4 = ST10 and cell E5 = ST1...can the formula total E4 & E5 as
ST=11

The OT and the ST letters just stand for 'overtime' and
'straight-time'

The following formula worked if the data is in B5 and C5. Could you
please edit it because the data is in B5 - AF5.
All your help is greatly appreciated, thanks a million!!

=IF(AND(LEFT(B5,2)="OT",LEFT(C5,2)="OT"),LEFT(B5,2)&"="&MID(B5,3,10)+MID(C5,
3,10),"NO OT")
Thanks,
 
Cheryl,

This assumes OTn in B5:AF5

="OT"&SUM(VALUE(RIGHT(B5:AF5,LEN(B5:AF5)-2)))

this is an array formula, so enter with Ctrl-Shift-Array

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top