Can an If statement answer an If statement?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=IF(Pace!J3>7,IF(Sheet1!AQ7<1.1,1320/FeetSecond!G4,(1320-(Sheet1!AR7*10)/FeetSecond!G4)),IF(Sheet1!AQ7<1.1,1320/FeetSecond!G4,(1320-(Sheet1!AR7*10)/FeetSecond!G4)))

Is it possible for an If to be answered by more If's ?
 
You can NEST IF statements to seven level in version of Excel to XL2003;
XL2007 allows more levels
Please tell us what your problem is
best wishes
 
yes,and you are on the right track....=IF(Pace!J3>7,IF(Sheet1!AQ7<1.1,"aq7 is
less than 1.1,IF(Sheet1!AQ7<2.1,"aq7 less than 2.1","aq7 out of range")))
the trick is to writing the series of ifs so that your requirements are
recognised by excel.Start of with a simplfied version of what you want.I
sometimes write dummy formuals like above to start with to see if my
conditions work like i want,or if i have to change them so excel deals with
them the way i want.
paul
(e-mail address removed)
remove nospam for email addy!
 
Back
Top