Log In
Register
Home
February 2, 2013
Offline
Hi All
I have updated excel file can any body help to update multi formula in status column.
Regards/Saliha
See Answer
July 16, 2010
Offline
Hi Saliha,
You can't test if a cell contains a date specifically, as dates are just numbers, so you're just as well off testing if the cell is empty or not, which is what the formula below does:
=IF(H4<>"","Cleared",IF(G4<>"",G4+7,IF(E4="",B4+28,IF(AND(B5<>"",C4="Courier"),E4+5,IF(AND(B4<>"",C4="Air"),E4+10,""))))) Mynda
September 18, 2019
Offline
Asalamo alikum
find the attachment i tried to resolve hope so you would be happy to see it.
Regards
Waqas Munir
Answers Post
February 2, 2013
Offline
Walaikum Assalam Waqas
Thanks for your formula really i am very appreciated.
regards/Saliha
February 2, 2013
Offline
Dear Waqas
possible to update Week instead of Date in Status column
regards/Saliha
February 2, 2013
Offline
Dear Mynda
Thanks for your formula, its working perfectly. can you help to use Week instead of date.
Regards/Saliha
February 2, 2013
Offline
Dear All
anybody please help in this regards
Regards/Saliha
July 16, 2010
Offline
Hi Saliha,
It's not clear what you mean by 'use week instead of date'. The formula doesn't check for a date as such, it just checks to see if the cell is empty or not. Having a week number or a date in the cell will make no difference. Please provide a specific example of what you mean so we can better understand what you're after.
Mynda
1 Guest(s)
