Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to create a formula in excel to call a result as either wild type
(WT), heterozygous (HET) or homozygous (HOM). This is how I was going about it, but Excel tells me that I have too many arguments for this function. (The value in cell W11 is based on a function). =IF(W11<=0.05,"WT",IF(AND(0.48<=W11,W11<=0.6),"HET "),IF(W11=1,"HOM")) Basically, I want it to give me the calls using the following ranges. If you or someone else can suggest another approach (without use of a macro), that would be greatly appreciated. WT 0.00-0.05 HET 0.48-0.60 HOM 1.00-1.07 Optimally, it would be nice to have some comment, such as 'review' or 'out-of-range' for any value that didn't fall within the above ranges. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nested IF function | Excel Worksheet Functions | |||
IF and OR nested function | Excel Discussion (Misc queries) | |||
can you nested sum and round function within if function? | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |