Subtract from a vlookup
Solved
sioum
-
sioum -
sioum -
Hello,
here is my issue with Excel, I made a function =if(isna(vlookup... which works very well except that in the result I would like to subtract another number...
where should I place this subtraction? or how should I proceed?
Thank you very much for your responses.
here is my issue with Excel, I made a function =if(isna(vlookup... which works very well except that in the result I would like to subtract another number...
where should I place this subtraction? or how should I proceed?
Thank you very much for your responses.
Configuration: Windows XP Internet Explorer 6.0
3 answers
Hello
difficult without the complete formula and 2 or 3 additional pieces of information
only hint:
=if(isna(vlookup(....................));""; vlookup(..............) - 10%)
--
Best regards
Wilfried
ps: don't forget to mark your thread as resolved when you find what you're looking for. Thank you
difficult without the complete formula and 2 or 3 additional pieces of information
only hint:
=if(isna(vlookup(....................));""; vlookup(..............) - 10%)
--
Best regards
Wilfried
ps: don't forget to mark your thread as resolved when you find what you're looking for. Thank you
Voici la traduction de votre texte :
Here is my formula in raw form
=IF(ISNA(VLOOKUP("TOTAL 20510009", 'GL CPTE 20-21.2008'!$A$5:$J$38, 9, 0)); ""; (VLOOKUP("TOTAL 20510009", 'GL CPTE 20-21.2008'!$A$5:$J$38, 9, 0)))
Here is my simplified formula:
=IF(ISNA(VLOOKUP(....................)); ""; VLOOKUP(..............)))
I would like to subtract a cell from this, it would look like this if it were possible:
=IF(ISNA(VLOOKUP(....................)); ""; VLOOKUP(..............)) - D8
Thank you for responding
Here is my formula in raw form
=IF(ISNA(VLOOKUP("TOTAL 20510009", 'GL CPTE 20-21.2008'!$A$5:$J$38, 9, 0)); ""; (VLOOKUP("TOTAL 20510009", 'GL CPTE 20-21.2008'!$A$5:$J$38, 9, 0)))
Here is my simplified formula:
=IF(ISNA(VLOOKUP(....................)); ""; VLOOKUP(..............)))
I would like to subtract a cell from this, it would look like this if it were possible:
=IF(ISNA(VLOOKUP(....................)); ""; VLOOKUP(..............)) - D8
Thank you for responding
Good evening
Logically, according to your explanations (?), it should be enough to enclose the entire second item of your formula in parentheses
that is, one immediately after the semicolon separating the ISNA part from the lookup part and one at the end of the formula and the other after the subtraction
=$IF(ISNA(VLOOKUP(........);"";(VLOOKUP(......................)-your number)
Best regards
--
The truth is not possessed; it is only sought.
Logically, according to your explanations (?), it should be enough to enclose the entire second item of your formula in parentheses
that is, one immediately after the semicolon separating the ISNA part from the lookup part and one at the end of the formula and the other after the subtraction
=$IF(ISNA(VLOOKUP(........);"";(VLOOKUP(......................)-your number)
Best regards
--
The truth is not possessed; it is only sought.