Have a Question?

If you have any question you can ask below or enter what you are looking for!



Excel

Hi All,

Can anybody help me to solve the below problem? I have data is as below. Please see my below condition. I have seen that data has not been changing whether value of G column is not 0, is blank, but still showing my data is Techandmate. But I need to data where G column data is 0, then Techandmate either is blank.


I am awaiting for your reply.

Thanks,

Debapriya

  Debapriya Bej

Hi Debapriya,

You can use normal if condition to solve this problem.

=IF(G2="","","TechandMate")

if your formula is below one then you will receive TechandMate wheather your value is 0 or blank because             bydefault excel consider 0 if cell is blank under formula-

=IF(G2=0,"TechandMate","No Match").

The correct formula is -

=IF(G2="","","TechandMate").


Thanks,

  Devbrat Tripathi       10 May 2017       0       0     

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any