View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Formula help please

=IF(A1="New York",25,"")
Regards,
Stefi

shallowz ezt *rta:

i am a noob when it comes to excel formula's

this is what i want i hope it can be done

if in cell A1 i have the word New York i would like to have cell A7 show a
number like a 25

Cell A1
New York

As soon is that is typed in

Cell A7
25
Pops up

what is the formula i put in A7 so that can happen please