by EnemySTAND
Last Updated July 18, 2018 18:03 PM

I have a sheet consisting of information on items. These items have string qualities (Located on columns C & D) that affect a numerical value (Located on Column E). How do I use the IF Formula to generate an expected number derived from what is in the C & D cells of the corresponding row?

Right now I have the following:

=IF(**C3**="Pistol";+2; IF(**C3**="SMG";+1; IF(**C3**="Shotgun";+2; IF(**C3**="Assault rifle";+2; IF(**C3**="Sniper rifle"; +3; IF(**C3**="Rocket launcher"; +4; IF(C3="Laser";+4; IF(**D3**="Tediore";-1; IF(**D3**="Torgue";+2; IF(**D3**="Chrono";-2))))))))))

- Serverfault Help
- Superuser Help
- Ubuntu Help
- Webapps Help
- Webmasters Help
- Programmers Help
- Dba Help
- Drupal Help
- Wordpress Help
- Magento Help
- Joomla Help
- Android Help
- Apple Help
- Game Help
- Gaming Help
- Blender Help
- Ux Help
- Cooking Help
- Photo Help
- Stats Help
- Math Help
- Diy Help
- Gis Help
- Tex Help
- Meta Help
- Electronics Help
- Stackoverflow Help
- Bitcoin Help
- Ethereum Help