Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |