Aug 29 2021 10:53 AM
Hello,
I'm quite a newbie using excel, and I need help with this one.
I have a sheet where I need to add a value if it meets a condition. For example, in a selected row if there is the word "Car" i need it to add 100 to the cells in front and if it have "house" instead add 75. IS this possible? i've tried some formulas but i always get an error even when i copi it exactly the same way
Aug 29 2021 11:08 AM
Better to have sample file to illustrate what do you mean exactly. And that could be dozen of reason why formula doesn't work.
You me modify attached more close to your case.
Aug 29 2021 11:09 AM
Please attach a small sample workbook.
Aug 29 2021 11:25 AM - edited Aug 29 2021 11:26 AM
wow, that was a fast reply. Thank you in advance.
i added a example below, i hope it helps you to help me!
Aug 29 2021 11:29 AM