Thread: i can't get this formula to work
View Single Post
  #2  
Old March 17th, 2010, 10:29 AM posted to microsoft.public.excel.worksheet.functions
Roger Govier[_8_]
external usenet poster
  
Posts: 338
Default 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,"")