If, then

  • Thread starter Thread starter Guest
  • Start date Start date
here is one way, if this will not do what you want post back with some more
information

=IF(A1>10,"Greater than ten",IF(A1>5,"Greater than five","less than or equal
to five"))

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
 
Your formula syntax is:

=IF(another_cell = this_value,THEN do this,ELSE do another thing)

or specifically (as an example),

=IF(A1=1,B1*C1,B1/C1)

which means,

IF cell A1 has a value of 1
THEN multiply the contents of B1 and C1
ELSE divide B1 by C1
 
Back
Top