merging two formulas 1

[jupops]

Hi Guys

Can anybody advise me, I have two different formulas that I use in two separate cells, can I merge the two formulas into one larger formula?

The two formulas are:

=IF(B2>1,B2,A1) - this will copy cells down with the previous cells contents if the cells are blank

and

=RIGHT(A1,11) – this will copy the 11 chars to the right

Therefore I am trying to copy the cell contents down with only the last 11 characters, is this possible??

Regards

Jupops

 

[cLFlaVA]

Something like this?

[tt]=IF(B2>1,B2,RIGHT(A1,11))[/tt]

??

*cLFlaVA
----------------------------
Ham and Eggs walks into a bar and asks, "Can I have a beer please?"
The bartender replies, "I'm sorry, we don't serve breakfast.

 

[jupops]

Just Perfect, thank you