Resolve three logical conditions using an if formula...

**sland01** · 05-07-2013, 09:12 PM

I need some help combining the three simple if formulas into one formula to resolve the three conditions that I have exampled in the attached workbook. Essentially I am looking for 3 logical conditions to resolve three (minimum) separate values.
M = a multiplier of 1000
C = a multiplier of 100
E = a multiplier of 1

I want a single formula to resolve the unit of measure in order to factor the value using a named factor value on a separate page.

HELP PLEASE!!!

**martindwilson** · 05-07-2013, 09:19 PM

=IF(A2="E",B2*Material_Factor,IF(A2="M",(B2/1000)*Material_Factor,IF(A2="C",(B2/100)*Material_Factor,0)))
and
=IF(A2="E",D2*Material_Factor,IF(A2="M",(D2/1000)*Material_Factor,IF(A2="C",(D2/100)*Material_Factor,0)))