| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
display actual value
Hello Excel Community,
I am creating a worksheet and having trouble with a formula which I need the excel to display the actual value for me. Here is the i.e. if (line 5 or line 15, whichever is MORE) A1 = 20 (@ line 5) A2 = 34 (@ line 15) B2 = ? I am using this formula: =IF(a1<=V2, "More","Less") But I need the actual value showing in B2. Please help me. Thank you. Kenny |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display results of formulas not the actual formula | Excel Discussion (Misc queries) | |||
| If..display "0", if greater than... display actual | Excel Discussion (Misc queries) | |||
| display actual number or zero, whichever is greater | Excel Discussion (Misc queries) | |||
| Actual value a non-zero number but display is Zero | Excel Discussion (Misc queries) | |||
| Display actual contents of cell | Excel Discussion (Misc queries) | |||
Threaded Mode
