View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BEEJAY
 
Posts: n/a
Default Nested If problems

Greetings:
Have the following, (used on multiple lines, in multiple workbooks)
Works great
=IF(D6="Alum",130,IF(D6="Rubber",145,0))

Need to expand it as follows:

=IF($E$5=0
then (D6="Alum",130,IF(D6="Rubber",145,0))
=IF($E$5=1
then =IF(D6="Alum",60,IF(D6="Rubber",70,0))

Have spent countless hours trying to "join" the above
- playing with the brackets and moving the Zero around, etc....
I'm STUCK.
I'm positive this should work if properly bracketted.
Due to the "application", I'd rather not change this to a look-up chart.
Thank-you