Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Excel 2013 question?
Does someone know how to calculate this? I want to have a cell show a name based on the sum of two other cells. For example if cells A1 and A2 sum between 0-3 then cell A3 shows Ann. If cells A1 and A2 sum between 4-6 then cell A3 shows David. Does this make sense? Thanks in advance for your answers.
3 Answers
- expletive_xomLv 76 years agoFavorite Answer
obvious questions are...How many names do you plan to have in total? can a1+b1 go below 0? can you go over 6?
i will make A3 go blank.
you can use an IF() function or if you have more than 2 names you can use a LOOKUP() function.
copy&paste this in A3
=IF(A1+A2<=0,"", IF(A1+A2<=3,"Ann", IF(A1+A2<=6,"david","")))
let me know how it works or if you add more info for a formula adjustment
- PipsyLv 56 years ago
Yea, I get what your saying and yes you can do this. However, you need to use VBA, that is, you need to write a macro for it. I don't have the time write the macro, but VBA is not a horribly difficult thing to learn or to convince someone someone to help you. An alternative idea, but not as good is do an if formula and then update a3 accordingly based upon the results of the if statement.
- 6 years ago
Thanks! I have about twenty names but I will try and follow the formula pattern.
