EXCEL problem with function" if"

  • Thread starter Thread starter Slowhand
  • Start date Start date
S

Slowhand

I have a problem like this:

=if(e16= ___;546)

where ___ is a text

I want to make this:
if in cell e16 I have "Poland" as a text, put 546 as a number,

Can you help me?
please write to me at e-mail
 
Hi
do you want the result in the same cell (that is E16 in your example).
If yes: not possible only with functions, VBA (an event procedure) is
required

If you want to use an adjacent cell (e.g. cell F16) enter the following
in F16:
=IF(E16="Poland",546,"not Poland")
 
Back
Top