wrt1mea
asked on
I need an excel formula
I will try to explain the best way I can. I am currently using this formula:
=(OR(C6="Complete",C6="Com plete - Successful"))+0
It tells me that if the value in C6 is either Complete or Complete - Successful to make it 1, or 100%.
I am wanting to also add to it to check to see if a accounting code matches (Column B on both Sheets), if it does, add the value thats in column K. If not, use the "Complete" or "Complete - Succcessul."
See the attached for an example file. I hope I have explained it well, if not, I will respond asap.
4-27-11.xlsx
=(OR(C6="Complete",C6="Com
It tells me that if the value in C6 is either Complete or Complete - Successful to make it 1, or 100%.
I am wanting to also add to it to check to see if a accounting code matches (Column B on both Sheets), if it does, add the value thats in column K. If not, use the "Complete" or "Complete - Succcessul."
See the attached for an example file. I hope I have explained it well, if not, I will respond asap.
4-27-11.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER