Need to Fix the Formula

[akinkaraman]

When C3 and C4 is empty it should be N/A but it comes as WRONG

How can I fix the formula at cell B3?

Thanks in advance..

 

[vletm]

Have You missed then 1st false answer?
=if(AND(...);if(B2="MCD";...;if(B2="MCE";...;if(B2="vel";...;"NA")));"NA")

 

[akinkaraman]

Could you please upload the file. I've changed the first file in my first post but I couldn't fix it yet.

Thanks..

 

[vletm]

Here You are ... with colors.

 

[akinkaraman]

Thank you my friend. I have same problem and I can not figure out what the wrong is.. I am doing as same as your formula.

Can you give a look? Where am I doing the wrong?

=IF(AND(I14=2,I15<8,I15>=0),INDEX(OFFSET('Index Tables'!D4:K4,MATCH(C8,'Index Tables'!B2:B6,0)-1,0),I14-1,I15+1)),"N/A")),"N/A")

 

[vletm]

Index's row value cannot be "N/A". Check syntaxes.
=if(logical_test,true,false)
=index(array,row_num,[column_num])
=offset(reference,rows,cols,[height],[width])
=match(lookup_value,lookup_array,[match_type])
Try to write Your formulas step by step ...
=if(AND(I14=2,I15<8,I15>=0),true,false) ... and next You'll write one step of true or false
=if(AND(I14=2,I15<8,I15>=0),index(array,row_num,[column_num]),false)
... and so on. I hope that You get an idea. Okay?

 

[akinkaraman]

Thank you..

 

[Carolinejames]

Hi,
when c3 and c4 is blank , it will come as "N/A".

See attached.

 

[akinkaraman]

Thanks

 

[akinkaraman]

Hi,
@Carolinejames

In that formula If C4>=8 B3 comes as 0
It should have been N/A