| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Novice user trying to use variables including text and numbers
hi, Rachel !
not sure i'm following you correctly (but) you might want to give a try... =--if(d7<"na",and(d7=2,f7<100)) hth, hector. __ OP __ 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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Threaded Mode
