Forum Discussion

Mindy Baird's avatar
Mindy Baird
Copper Contributor
Jun 24, 2018

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