Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Lambodar Eng.   on Aug 18 In MS Office Category.

  
Question Answered By: Joel Brown   on Aug 18

I'll try this. Will this also be able to work on other sheets or
workbooks?

Here's the function I'm using in Excel, if it helps:

=IF($U$3="pe",'G4'!T352, IF($U$3="lo",('G4'!I352/'G4'!Q352)-1, IF
($U$3="hi",('G4'!I352/'G4'!P352)-1, IF($U$3="dl",('G4'!I352/'G4'!
L352)-1, IF($U$3="dh",('G4'!I352/'G4'!K352)-1, IF($U$3="vl",('G4'!
M352/100000000), IF($U$3="yt",('G4'!I352/'U:\Research\[G4K
010305.xls]G4'!J352)-1,IF($U$3="wk",('G4'!I352/'U:\Research\[G4K
013105.xls]G4'!J352)-1,'G4'!O352))))))))

This is what is in cell P3. Cell P4 would be the same formula except
it would reference row 353

Share: 

 

This Question has 3 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Limited with IF Then Else Nesting Or get search suggestion and latest updates.


Tagged: