| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
values in IF formulas
I have a basic table whereby if a cell is less than zero or greater than
zero, I want the next cell to display a '-' or '+' sign. However, the formula (as shown below) shows that the name is not valid or contains an error: I7: =IF(H7<0, [-], [+]) How do I make this work? Is there a problem with using non-numbers or letters in IF formulas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Easily convert all formulas in 3d spreadsheet to values? | Excel Worksheet Functions | |||
| Copy Values in a cell (derived from formulas) | Excel Worksheet Functions | |||
| How do I clear data values wthout losing the formulas? | Excel Worksheet Functions | |||
| differentiating between formulas and values | Excel Discussion (Misc queries) | |||
| Formulas with "Y" & "N" values | Excel Discussion (Misc queries) | |||
Threaded Mode
