Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello my formula does not work - it does not give me an error message but
the answer is wrong THis is what I have Cell a2=date, cell F2=total sales in cell G2 I have the following formula =IF(A21/1/2009,F2*15%,IF(A2<1/1/9,F2*17.5%,FALSE)) in PLain english if the date in cell A2 is greater than or equal to 1/1/2009 then multiple f2 by 15%, if the date in cell A2 is less than 1/1/09 multiply by 17.5% thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula involving buckets | Excel Worksheet Functions | |||
Formula help involving a Time value please. | Excel Discussion (Misc queries) | |||
condition formatting involving formula | Excel Worksheet Functions | |||
Formula involving a letter that has to have a numeric value | Excel Worksheet Functions | |||
Help with a formula involving 3 columns | Excel Worksheet Functions |