If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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,"") . |
Thread Tools | |
Display Modes | |
|
|