| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i can't get this formula to work
i'm trying to write a formula where if the cell below it minus the active
cell is -21< x -23 then write one, else leave it blank. so here's what i got so far, i think i'm just getting the parentheses wrong =if((AND((c2-c1)*24)<-21,((c2-c1)*24)-23),1,"") i tried writing a simpler formula along the same lines and this one works =if((AND(j3<-21,j3-23)),1,"") |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
i can't get this formula to work
Hi Kyle
Try =IF(AND((C2-C1)*24<-21,(C2-C1)*24-23),1,"") -- Regards Roger Govier kyle wrote: i'm trying to write a formula where if the cell below it minus the active cell is -21< x -23 then write one, else leave it blank. so here's what i got so far, i think i'm just getting the parentheses wrong =if((AND((c2-c1)*24)<-21,((c2-c1)*24)-23),1,"") i tried writing a simpler formula along the same lines and this one works =if((AND(j3<-21,j3-23)),1,"") |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
i can't get this formula to work
Kyle,
Try this =IF(AND((C2-C1)*24<-21,(C2-C1)*24-23),1,"") -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "kyle" wrote: i'm trying to write a formula where if the cell below it minus the active cell is -21< x -23 then write one, else leave it blank. so here's what i got so far, i think i'm just getting the parentheses wrong =if((AND((c2-c1)*24)<-21,((c2-c1)*24)-23),1,"") i tried writing a simpler formula along the same lines and this one works =if((AND(j3<-21,j3-23)),1,"") |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
i can't get this formula to work
thanks, that did it
"Roger Govier" wrote: Hi Kyle Try =IF(AND((C2-C1)*24<-21,(C2-C1)*24-23),1,"") -- Regards Roger Govier kyle wrote: i'm trying to write a formula where if the cell below it minus the active cell is -21< x -23 then write one, else leave it blank. so here's what i got so far, i think i'm just getting the parentheses wrong =if((AND((c2-c1)*24)<-21,((c2-c1)*24)-23),1,"") i tried writing a simpler formula along the same lines and this one works =if((AND(j3<-21,j3-23)),1,"") . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to work in a 3-d reference with 2 work books | Excel Worksheet Functions | |||
| Sorting the cells of a formula causes the formula to not work | Excel Worksheet Functions | |||
| WHY doesn't formula work??? | Excel Discussion (Misc queries) | |||
| Why does this formula not work? | Excel Discussion (Misc queries) | |||
| A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
Linear Mode
