Adding an aditional forumla to this one
Hi Guys
Had some great help yesterday on here from Bob Phillips (Thanks again Bob) I know have the following formula that works great. =IF(AND($C$66=2,--TEXT($D$66,"yyyymm")<=--TEXT(O3-DAY(O3)+1,"yyyymm")),LOOKUP(DATEDIF($D$66,O3+1,"M" ),{0,4,8}, {0,0.7,1})*$F$66,0) But I need 1 last element added to it and can't seem to get it right. Basically the above formula works if C66=2, BUT if B66 doesnt = 2 I need to apply this IF($G44<O3,$F66,"") Thanks in advance |
Adding an aditional forumla to this one
BUT if B66 doesnt = 2 I need to apply this
Do you mean C66? If so, try: =IF(AND($C$66=2,--TEXT($D$66,"yyyymm")<=--TEXT(O3-DAY(O3)+1,"yyyymm")),LOOKUP(DATEDIF($D$66,O3+1,"M" ),{0,4,8}, {0,0.7,1})*$F$66,IF($G44<O3,$F66,"")) Regards, Fred "Mark D" wrote in message ... Hi Guys Had some great help yesterday on here from Bob Phillips (Thanks again Bob) I know have the following formula that works great. =IF(AND($C$66=2,--TEXT($D$66,"yyyymm")<=--TEXT(O3-DAY(O3)+1,"yyyymm")),LOOKUP(DATEDIF($D$66,O3+1,"M" ),{0,4,8}, {0,0.7,1})*$F$66,0) But I need 1 last element added to it and can't seem to get it right. Basically the above formula works if C66=2, BUT if B66 doesnt = 2 I need to apply this IF($G44<O3,$F66,"") Thanks in advance |
Adding an aditional forumla to this one
I answered in the original thread.
-- HTH Bob "Mark D" wrote in message ... Hi Guys Had some great help yesterday on here from Bob Phillips (Thanks again Bob) I know have the following formula that works great. =IF(AND($C$66=2,--TEXT($D$66,"yyyymm")<=--TEXT(O3-DAY(O3)+1,"yyyymm")),LOOKUP(DATEDIF($D$66,O3+1,"M" ),{0,4,8}, {0,0.7,1})*$F$66,0) But I need 1 last element added to it and can't seem to get it right. Basically the above formula works if C66=2, BUT if B66 doesnt = 2 I need to apply this IF($G44<O3,$F66,"") Thanks in advance |
Adding an aditional forumla to this one
hi,
try =IF(AND($C$66=2,--TEXT($D$66,"yyyymm")<=--TEXT(O3-DAY(O3)+1,"yyyymm")),LOOKUP(DATEDIF($D$66,O3+1,"M" ),{0,4,8}, {0,0.7,1})*$F$66,IF($G44<O3,$F66,"")) "Mark D" wrote: Hi Guys Had some great help yesterday on here from Bob Phillips (Thanks again Bob) I know have the following formula that works great. =IF(AND($C$66=2,--TEXT($D$66,"yyyymm")<=--TEXT(O3-DAY(O3)+1,"yyyymm")),LOOKUP(DATEDIF($D$66,O3+1,"M" ),{0,4,8}, {0,0.7,1})*$F$66,0) But I need 1 last element added to it and can't seem to get it right. Basically the above formula works if C66=2, BUT if B66 doesnt = 2 I need to apply this IF($G44<O3,$F66,"") Thanks in advance |
Adding an aditional forumla to this one
Sorry Fred yes I meant C66,
"Fred Smith" wrote: BUT if B66 doesnt = 2 I need to apply this Do you mean C66? If so, try: =IF(AND($C$66=2,--TEXT($D$66,"yyyymm")<=--TEXT(O3-DAY(O3)+1,"yyyymm")),LOOKUP(DATEDIF($D$66,O3+1,"M" ),{0,4,8}, {0,0.7,1})*$F$66,IF($G44<O3,$F66,"")) Regards, Fred "Mark D" wrote in message ... Hi Guys Had some great help yesterday on here from Bob Phillips (Thanks again Bob) I know have the following formula that works great. =IF(AND($C$66=2,--TEXT($D$66,"yyyymm")<=--TEXT(O3-DAY(O3)+1,"yyyymm")),LOOKUP(DATEDIF($D$66,O3+1,"M" ),{0,4,8}, {0,0.7,1})*$F$66,0) But I need 1 last element added to it and can't seem to get it right. Basically the above formula works if C66=2, BUT if B66 doesnt = 2 I need to apply this IF($G44<O3,$F66,"") Thanks in advance . |
All times are GMT +1. The time now is 06:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com