LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 622
Default Novice user trying to use variables including text and numbers

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
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
novice excel 2007 user needs help Jamie New Users to Excel 4 March 1st 08 10:13 AM
Several things if anyone is willing to help a total novice user ofExcel NickTheBatMan Excel Discussion (Misc queries) 2 November 24th 07 08:31 AM
Hiding Worksheets and Unhiding them easily for Novice User Jugglertwo Excel Discussion (Misc queries) 5 June 5th 07 02:53 PM
Very Novice Excel user with security question Ralph Malph Excel Discussion (Misc queries) 5 March 23rd 06 06:33 PM
Format a cell with numbers and user defined text Rod R. Excel Discussion (Misc queries) 0 March 30th 05 04:31 PM


All times are GMT +1. The time now is 01:55 PM.

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

About Us

"It's about Microsoft Excel"