in excel 2000 IF function using "E" does not calculate properly IF(C2=("E"),($O2),($O2))))))

Thanks for contacting us on Experthelp. My name is Tarun and I will be happy to assist you. 

Based on your query below, I have checked the excel formula and would like to share my views on it.

1. You do not need to enclose "E" in a bracket and enclosing it in double quotes " " should do the trick.

2. Since if condition check the expression and gives the output based on whether the condition is true of false. In below query, since you are using O2 in both true as well as false condition and it will not make any difference and will always return the value from cell O2.

Please refer the simplified version of the formula. IF(C2="E",$O2,"-") - It will check if cell C2 contains E then it will give the value of cell O2 and if the condition is false, it will give hyphen "-" as an output.

I hope this will resolve your query. 

Should you need any further assistance or clarification, please feel free to let me know.

Thank you, 

Tarun G CFA

Thanks Bill for your response.

In Excel 2000, there used to be a limit of 256 characters. However, in order to serve you, would you be able to share the spreadsheet along with the formula or if possible, kindly share the complete formula. In case, something is missing then I will correct the formula or if this is due to the limit of characters in a formula, then I will try to optimize it to ensure that it should display correctly at your end in Excel 2000.

Thanks,

Tarun

Hi Bill,

For your convenience, please use my email address: C**n@gmail.com to share the file.

Thanks,

Tarun

Hi Bill, 

I believe the proposed solution has solved your issue. Please free to revert in case of any further queries.