Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Language "lingo"
I need a cell to display "yes" if the total of two cells is negative and no
if posititive. Also, is there a computer language that I should learn that would help me figure out these type of issues in the future? |
#2
|
|||
|
|||
One way:
=IF((A1+B1)<0, "yes", "no") which assumes that a zero value should be "no". There's no special language you should learn for using XL itself. Use Help liberally instead. If you want to learn to use macros, they're written in Visual Basic for Applications (VBA). But that generally won't help you with worksheet functions. In article , "NeedtoExcel" wrote: I need a cell to display "yes" if the total of two cells is negative and no if posititive. Also, is there a computer language that I should learn that would help me figure out these type of issues in the future? |
#3
|
|||
|
|||
=IF(A1+B1<0,"yes",IF(A1+B10,"no","zero"))
Excel worksheets are not a language as such, more formula syntax. You need to get a good understanding of what formulas are available and how they work, be able to break your problem down into logical parts, understand how to apply the formulae to these logical parts, how to identify test conditions, and test them. In other words, seek out information, try things, follow these NGs to see what others are asking, and the responses, and practice. -- HTH RP (remove nothere from the email address if mailing direct) "NeedtoExcel" wrote in message ... I need a cell to display "yes" if the total of two cells is negative and no if posititive. Also, is there a computer language that I should learn that would help me figure out these type of issues in the future? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |