J
jayhawk1919
This is the forumla I'm trying to write, but it won't work. I suspect
it has to do with trying to nest more than 7 "IF"s. Is there any way
to nest more, or to write it in a different way so I don't have to nest
more than 7?
This is what I wanna write:
=IF(INDIRECT("F"&"1021")="Yes,
DT",E516*0.8,IF(INDIRECT("F"&"1021")="No,
DT",E516*1.25,IF(INDIRECT("F"&"1021")="Yes,
DD",E516*0.8,IF(INDIRECT("F"&"1021")="No,
DD",E516*1.5,IF(INDIRECT("F"&"1021")="Yes,
CS",E516*0.8,IF(INDIRECT("F"&"1021")="No,
CS",E516*1.1,IF(INDIRECT("F"&"1021")="Yes,
FB",E516*0.8,IF(INDIRECT("F"&"1021")="No,
FB",E516*1.1,IF(INDIRECT("F"&"1021")="Motion",E516*0.9,"Blah")))))))
it has to do with trying to nest more than 7 "IF"s. Is there any way
to nest more, or to write it in a different way so I don't have to nest
more than 7?
This is what I wanna write:
=IF(INDIRECT("F"&"1021")="Yes,
DT",E516*0.8,IF(INDIRECT("F"&"1021")="No,
DT",E516*1.25,IF(INDIRECT("F"&"1021")="Yes,
DD",E516*0.8,IF(INDIRECT("F"&"1021")="No,
DD",E516*1.5,IF(INDIRECT("F"&"1021")="Yes,
CS",E516*0.8,IF(INDIRECT("F"&"1021")="No,
CS",E516*1.1,IF(INDIRECT("F"&"1021")="Yes,
FB",E516*0.8,IF(INDIRECT("F"&"1021")="No,
FB",E516*1.1,IF(INDIRECT("F"&"1021")="Motion",E516*0.9,"Blah")))))))