simple excel formula

  • Thread starter Thread starter Newbie
  • Start date Start date
N

Newbie

I would like to write a simple formula...if the value in
cell B4 is greater than the value in cell D4 then
print "1" in cell E4.

Do you have any advise as to where I can begin learning
simple excel formulas like this one? Is there a list of
common formulas available on line or in books? Thanks for
your help.
 
First, you can continue reading these newsgroups (though the
microsoft.public.worksheet.functoin group would be more appropriate than
..programming).

There are innumerable books out there on using XL. The hands-down best
I've seen on formulas is John Walkenbach's "Excel 200x Formulas":

http://j-walk.com/ss/books/index.htm

If you can find a copy of the 2000 version, you may save some money and
have all you need. The 2002 version is better if you want more financial
functions. I haven't extensively reviewd the 2003 version, but formulas
haven't really changed since XL97.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Condition 4
Excel Need Countifs Formula Help 0
Filter with an IF, AND, NOT formula 1
macro to run in event of cell value <>"" 3
Supressing a #VALUE! error returned? 3
Excel VBA 1
Help needed to Create Formulae 2
formula to change font colour depending on which cell it has used 1

Back
Top