If, then

[new newbie]

How do I use an IF, THEN calculation based on the value of another cell

 

[Paul B]

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 **

 

[BenjieLop]

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