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 |