if one cell have number then other cell should have text

[vipulhumein]

hi
can u please solve this... if Cell A1 have text "FOC" then Cell B1 should have number(any number) and if Cell A1 have number then Cell B1 Should have "FOC".

Please Solve this immediately

Thanks in Advance

[martindwilson]

Do you mean
=IF(A1="FOC",1,IF(ISNUMBER(A1),"FOC","")) ?

[stnkynts]

lol.....immediately

[Jakobshavn]

In B1 enter:

=IF(ISNUMBER(A1),"FOC",IF(A1="FOC",1,""))

[vipulhumein]

if A1 have 'FOC" then B1 should have any number and if A1 have any number then B1 should have "FOC" . means if A1 have any number then B1 SHOULD BE RESTRICTED WITH "FOC" AND IF A1 HAVE "FOC' THEN IN B1 WE CAN PUT ANY NUMBER OTHER THAN "foc"

i think this will be solve only through VBA