Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
SIMPLE VBA MACRO FOR CONDITIONAL FORMATTING | Excel Discussion (Misc queries) | |||
simple conditional formatting | Excel Discussion (Misc queries) | |||
Conditional formatting, simple question... | Excel Worksheet Functions |