| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Function
I keep getting the wrong result when I use =IF(G20<=+-H20,"OK","PROBLEM"). I
know the result should be "Problem" due to G20 being less than H20 -- Bushy |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Function
Hi,
Delete the "+-" If you need h20 to be a negative value wrap it in (). John "Bushy" wrote in message ... I keep getting the wrong result when I use =IF(G20<=+-H20,"OK","PROBLEM"). I know the result should be "Problem" due to G20 being less than H20 -- Bushy |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Function
Try
=IF(G20<=ABS(H20),"OK","PROBLEM") If this post helps click Yes --------------- Jacob Skaria "Bushy" wrote: I keep getting the wrong result when I use =IF(G20<=+-H20,"OK","PROBLEM"). I know the result should be "Problem" due to G20 being less than H20 -- Bushy |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Function
What's in G20 and what's in H20? And what should be returned with those two
values? Maybe: =IF(G20<=-H20,"OK","PROBLEM") or =IF(G20<=-abs(H20),"OK","PROBLEM") or =IF(G20<=H20,"OK","PROBLEM") Bushy wrote: I keep getting the wrong result when I use =IF(G20<=+-H20,"OK","PROBLEM"). I know the result should be "Problem" due to G20 being less than H20 -- Bushy -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Hybrid Mode
