Hi All,
I am trying to write an IF statement..
condition is as below.
I have four zones. East, North, West & South.
If goods arrive in my store after a particular date, then I should be returned a value as "LATE FOR SALE"
I need to put a condition. If the zone is ÉAST, & the goods arriving date is after 20th of May, I should be told as "Late for sale"
for west - 22, May
North - 25th May
South - 28th may
can you guys help me please ? Thanks
Mani
In the attached is one method of doing this. It uses a small lookup table to make it easy to adjust dates.
BSB
If you don't care about the year (so any date from 1 Jan to 20 May with 'East' is 'on time', but any date from 21 May to 31 Dec with 'East' is 'late') then you can use multiple AND/OR checks like this:
Formula:
Please Login or Register to view this content.
But if the year in the date matters (which it probably does!), then you would be best to put a list of zones and dates elsewhere on the sheet (or on another sheet), then refer to those in the formula. If you listed the zones in F2:F5 and dates in G2:G5, then this would work:
Formula:Please Login or Register to view this content.
Here's a file showing both working: IF with Zone and Date _ for Shadmani.xlsx
This is ok for just four zones/dates, but if you're going to have a lot of different zones and/or lots of different dates, then it would be better to use some sort of Lookup (VLOOKUP, INDEX/MATCH, etc) - if that's the case, let us know and we can give you a better solution.
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
Not sure what you're looking for here, but maybe this will help.
Your description is not specific so you're not going to get a specific answer.
Formula:Please Login or Register to view this content.
where
zone is the cell containing the zone for this sale
arrivaldate is the cell containing the arrival date for this sale
latedatexxxx is the cell containing the late date for the corresponding zone
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks