If, then

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

here is one way, if this will not do what you want post back with some more
information

=IF(A110,"Greater than ten",IF(A15,"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 **
"new newbie" new wrote in message
...
How do I use an IF, THEN calculation based on the value of another cell

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


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


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=265918