At work I am trying to update a sheet so that if one cell contains a specific string, in this case its the product name, if the string matches then the price column will automatically be set to the price for that product. I was trying something like =IF(A1='delrin', D1=3.25), but it doesnt seem to work, no matter how i format the string. Maybe a double equal sign is needed to test for equality like in C, or there is a different operator for testing string equality like 'eq' in perl. as you can probably tell, i am not very fluent in Windows, Unix is more my style, so i could really use some assistance. Thank you in advance for any help
Bookmarks