LinkBack URL
About LinkBacks
Hi,
I am trying to apply a formula with multiple if conditions in Column D, but I could not get the correct result. I need your simple solution to get the expected result as in Column G.
Please Login or Register to view this content.
Hi,
I am trying to apply a formula with multiple if conditions in Column D, but I could not get the correct result. I need your simple solution to get the expected result as in Column G.
Please Login or Register to view this content.
Although it is helpful to show us expected results, you are going to have to explain why you expect that result. What are the conditions and calculations you want to apply to each of those cases?
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Hi Jeff,
Expected the results are in Column G. I have already have a formula in Column D only some part of it works. I added one more formula to it but it does not give the results (Highlighted in yellow).
This part of the when include, it is not giving the result.Please Login or Register to view this content.
This part of the formula giving the correct result.Please Login or Register to view this content.
All the conditions are mentioned in the formula.
But if the formula is giving the wrong results, then the conditions are not what you intend. That is why I'm asking for the conditions described in text, so I can compare that to the formula and see what doesn't match.Originally Posted by Barieq
Thanks, now the below formula works. But it is giving me error in xls file because of more level of nested formulas. Anyway I am attaching the file with all the conditions, could you please reduce the below formula.
Please Login or Register to view this content.
Is the problem that the formula in post #5 doesn't work in 97-2003 workbooks which use the .xls file format?
I ask because in the workbook attached to post #5 all 104 values in column D match those in column G.
EDIT: The following may work in the 97-2003 versions:Formula:
Please Login or Register to view this content.
Last edited by JeteMc; 09-30-2023 at 10:27 AM. Reason: Added edit
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Yes now the formula is working in xlsx, I want it to apply to .xls file but it gives me error. More levels of nesting..Is the problem that the formula in post #5 doesn't work in 97-2003 workbooks which use the .xls file format?
I ask because in the workbook attached to post #5 all 104 values in column D match those in column G.
EDIT: The following may work in the 97-2003 versions:Formula:Please Login or Register to view this content.
Last edited by Barieq; 09-30-2023 at 04:02 PM.
Re: Multiple If Condition Formula
Hi,
to check on some Microsoft website : if I well remember the imbrated IF are limited to seven levels under 2003 versions
and as your formula has more than seven so the reason why the error arises …
As a reminder this is the VBA forum section, so next time for a formula create your thread in the appropriate forum section !
Yes I know it's VBA Forum, the formula I want to apply to the VBA Code. Can you provide me the code vba for this multiple conditions.
Last edited by Barieq; 09-30-2023 at 04:42 PM.
Re: Multiple If Condition Formula
Anyway as under Excel 2003 the nested IF can't be over 7 so do you really need to go with very old .xls workbook format ?
If yes rather than such poor IF formula you should better use a VLOOKUP formula on a range / table
and once it works manually if really a VBA procedure is necessary then easy to start with the Macro Recorder …
IF function nested formulas and avoiding pitfalls
Thanks for your information. I will solve it by changing the file format.
@Marc L,
Solved... With only three If's
Please Login or Register to view this content.
Re: Multiple If Condition Formula
Well done, must work even under 2003 version !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks