LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 2
Default Novice user trying to use variables including text and numbers

I'm completely self taught so hope this is possible

I've tried a number of formula but the nearest is

=IF(($D$7<2)*($F$7100)*($D$7="NA"),0,1)

what i need to do is assign a value of 1 or 0 when adding different arguments

I need a result of 0 if D1 is under 2.00 F1 is over 100 or the result in the D coloum reads NA, can't change NA to read something else as its imported from another source.

I also need a result of 1 if D1 is 2.00 or over, if F1 is under 100, everyway i try to do this counts NA as being larger than 2.00

Any help gratefully received, thanks
 
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 02:09 AM.

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"