Hi

=IF(RIGHT(A1,"SWR"),3,6)
fill down your column (move cursor over bottom right hand corner of the cell
when you see a +, double click)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Rao Ratan Singh" wrote in message
...
My sheet has columns like this
A
1. 63mmx 4kg
2. 75mmx 4kg SWR

How can i detect that if a1:a2 is right,3 "swr", that it should be
returned
3 otherwise 6.

How can i add =right function with conditional formula.

Help me

Rao Ratan singh