Problem with nesting an OR in a formula
Hi
I have a formula which is starting to get beyond my knowledge, I don't know
where to put the OR!
=IF(LEFT(C10,1)="F","AC"&MID(C10,2,7),"AC"&MID(C10 ,1,7))
My problem is I would like to test if the 1st character is an F or 0 then
drop it, but I still need an 8 digit account number. I can see from the
help it is possible but whereever I put it I just get an error in the
formula
Can anyone help?
Thanks
Wendy
|