Hi all
please I want formula
The explanation on attached below
Thanks
Hi all
please I want formula
The explanation on attached below
Thanks
Last edited by thair; 05-07-2012 at 12:43 PM. Reason: not comply with rule
Hi
Try this:
=IF(MONTH(A2)<MONTH(DATE(2012,4,1)),B2*40,B2*39)
In your file the Date of loading in 3rd row is not a date.. Pls check that before trying the above formula
Click *, if my suggestion helps you. Have a good day!!
Try this formula =IF(A2<DATE(2012,1,4),B2*40,B2*39)
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
just another solution if not the above
i'll just take your explanation
so this date will not be included and it will only get the number from the column quantitybefore and after 1/4/2012
=IF(A2<DATE(2012,4,1),B2*40,IF(A2>DATE(2012,4,1),B2*39,B2))
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Hi
Thank you to replied me
yeah was wrong inputIn your file the Date of loading in 3rd row is not a date.. Pls check that before trying the above formula
Thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks