Formula question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I cell A1 contains 30907, I want A2 to be .14 otherwise I wnat A2 to be
blank. How do I do this
 
In cell A2 enter this formula:

=IF(A1=30907,.14,"")

Or, if A1 is formatted as Text, then use this:

=IF(A1="30907",.14,"")

HTH,
Elkar
 
Back
Top