Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default Matching 2 figures if not =0 rtn true

Assuming your values are in B2 and C2, try this:

=IF(AND(B2<0,C2<0),TRUE,FALSE)

Can be simplified, but this matches with your description.

Hope this helps.

Pete

FL Trouble wrote:
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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying figures from Access to Excel dalymjl Excel Worksheet Functions 0 September 29th 06 05:49 PM
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 03:56 AM
Validate MsgBox Entry to Data in Cells David Excel Discussion (Misc queries) 13 December 21st 05 10:31 PM
True to TRUE Nikki@CustomMortgageSolutions Excel Discussion (Misc queries) 3 June 14th 05 05:35 PM
Calculate minus figures only Nigel Excel Discussion (Misc queries) 0 March 30th 05 10:31 AM


All times are GMT +1. The time now is 08:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"