Thread: Simple conditional formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
JC Home JC Home is offline
external usenet poster
  
Posts: 4
Default Thanks! Simple conditional formula
That did it - Thanks!!!

I was trying to use the syntax from the VBA Editor's help and that didn't
quite cut it.

And sorry for the multiple posts :(
--
Jeff Ciaccio
Dallas, GA

"Tom Ogilvy" wrote in message
...
=if(A1B1,"A1 is bigger",if(A1=B1,"They are equal","B1 is bigger"))

Regards,
Tom Ogilvy

"JC Home" wrote in message
...
I am trying to write a simple calculation based on the values in certain
cells. I would like my display to be different depending on which of
two
cells is greater and a different display again if they are equal.

Can somebody please tell me how this is done in Excel 2000?

Thanks!!

--
Jeff Ciaccio
Dallas, GA
http://mywebpages.comcast.net/ciaccio8515







Reply With QuoteReply With Quote