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,"") |
Thread Tools | |
Display Modes | |
|
|