Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
-/+ forumla | Excel Worksheet Functions | |||
Chart that will expand to aditional rows | Charts and Charting in Excel | |||
Help with Forumla | Excel Worksheet Functions | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
adding aditional taxes | Excel Discussion (Misc queries) |