Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help with formula
I am trying to accomplish the following;
If the dates 1 and 2 match or date 2 is earlier than date 1 add 20 points to the total; if both dates dont match or the date 2 is later than than date 1 no additional points are added to the total =IFSUM(I7M7)=N7+20,(I7)<(I7)=N7+0 CELL (I7) DATE (M7) DATE (N7) SUM TOTAL =SUM(N1:N6) PJEAN |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help with formula
On Fri, 19 Sep 2008 21:16:00 -0700, PJEAN
wrote: I am trying to accomplish the following; If the dates 1 and 2 match or date 2 is earlier than date 1 add 20 points to the total; if both dates don’t match or the date 2 is later than than date 1 no additional points are added to the total =IFSUM(I7M7)=N7+20,(I7)<(I7)=N7+0 CELL (I7) DATE (M7) DATE (N7) SUM TOTAL =SUM(N1:N6) PJEAN Try this formula in cell N7: =SUM(N1:N6)+20*(M7<=I7) Hope this helps / Lars-Åke |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help with formula
Thanks "Lars-Ã…ke Aspelin" wrote: On Fri, 19 Sep 2008 21:16:00 -0700, PJEAN wrote: I am trying to accomplish the following; If the dates 1 and 2 match or date 2 is earlier than date 1 add 20 points to the total; if both dates dont match or the date 2 is later than than date 1 no additional points are added to the total =IFSUM(I7M7)=N7+20,(I7)<(I7)=N7+0 CELL (I7) DATE (M7) DATE (N7) SUM TOTAL =SUM(N1:N6) PJEAN Try this formula in cell N7: =SUM(N1:N6)+20*(M7<=I7) Hope this helps / Lars-Ã…ke |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|