Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
There are many ways to write this that should all work. Here's one:
=IF(D1="NA",0,IF(AND(D1=2,F1<100),1,0)) But, in your example you say those starred should all be a 1. But you said 1 should be returned if the rate is over 2.00 AND count is under 100. (did you mean OR?)And you said anything with an NA should return 0. By my reading, all of your examples should return 0. Also, in your 2nd post you suddenly mentioned returning a 2. Is that a typo? So, what is wrong in your posts? Need to get that fixed first. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
novice excel 2007 user needs help | New Users to Excel | |||
Several things if anyone is willing to help a total novice user ofExcel | Excel Discussion (Misc queries) | |||
Hiding Worksheets and Unhiding them easily for Novice User | Excel Discussion (Misc queries) | |||
Very Novice Excel user with security question | Excel Discussion (Misc queries) | |||
Format a cell with numbers and user defined text | Excel Discussion (Misc queries) |