Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching 2 figures if not =0 rtn true
I have tried using an if statement with 0 and <0 but I'm not getting correct
result I did an and statement that works for just 1 condition. Is there something that I can use instead of greater than or less than for not equal? Example I may have a -1 in column b and I may have 3 in column C and I want that to be true. If I have a 0 in column b and a 1 in column C I want it to be false. If I have a 2 in B and 3 in C I want it to be true. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying figures from Access to Excel | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Validate MsgBox Entry to Data in Cells | Excel Discussion (Misc queries) | |||
True to TRUE | Excel Discussion (Misc queries) | |||
Calculate minus figures only | Excel Discussion (Misc queries) |