Forum Discussion
Mindy Baird
Jun 24, 2018Copper Contributor
How to write a sum formula that compares
I am trying to write a formula that would take the value in the space and give it another value.
For instance, I have items in a row ranked from 1-3. If the value is a 1, I want excel to give it a value of 50. If it is a 2, a value of 25; and lastly, if it is a 3, a value of 5. Then I want the row to do a sum of the whole row.
I tried =IF(1,50,0),=IF(2,25,0),=IF(3,5,0).
But it did not work. It kept giving the row a value of "false".
It's been a long time since I've needed to use formulas, so be kind. :-)
Thank you for your help!
2 Replies
- Marvin OcoSteel Contributor
- Mindy BairdCopper ContributorThank you for your reply. The deadline had passed and I no longer need this.