Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using Function IF
Cell A1 is a variable
Cell A2 is a variable Cell A6=IF(ABS(A1-A2)<2,TRUE,FALSE) Instead of Displaying True and False when data are inserted into the cells, could i display other words, such as YES and NO? If can, how do i do it? |
#2
|
|||
|
|||
Certainly
=IF(ABS(A1-A2)<2,"Yes","No") -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "cihow81" wrote in message ... Cell A1 is a variable Cell A2 is a variable Cell A6=IF(ABS(A1-A2)<2,TRUE,FALSE) Instead of Displaying True and False when data are inserted into the cells, could i display other words, such as YES and NO? If can, how do i do it? |
#3
|
|||
|
|||
One way:
Change formula in A6 to =IF(ABS(A1-A2)<2,TRUE,FALSE)*1 and custom number the cell to be: "YES";;"NO" Another way: Change formula in A6 to =IF(ABS(A1-A2)<2,"YES,"NO") The first method is probably preferred if there are other cells with formulae that refer to cell A6 and expect it to contain a boolean value. "cihow81" wrote in message ... Cell A1 is a variable Cell A2 is a variable Cell A6=IF(ABS(A1-A2)<2,TRUE,FALSE) Instead of Displaying True and False when data are inserted into the cells, could i display other words, such as YES and NO? If can, how do i do it? |
#4
|
|||
|
|||
Dear chihow,
yes you can. The formula would look liie this: A6=IF(ABS(A1-A2)<2,"yes","no") "cihow81" wrote: Cell A1 is a variable Cell A2 is a variable Cell A6=IF(ABS(A1-A2)<2,TRUE,FALSE) Instead of Displaying True and False when data are inserted into the cells, could i display other words, such as YES and NO? If can, how do i do it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Accessing a Function | Excel Discussion (Misc queries) | |||
Access Module coded converted to Excel Function | Excel Discussion (Misc queries) | |||
Function in XL or in VBA for XL that pulls numeric digits from a t | Excel Discussion (Misc queries) | |||
Excel function help facilities | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) |