View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default simple excel formula

Hi
put the following formula in E4
=IF(B4D4,1,"")

--
Regards
Frank Kabel
Frankfurt, Germany


Newbie wrote:
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.