Complex formula to return result - thats over my head

jarthurs

New member
Joined
Feb 13, 2016
Messages
1
Reaction score
0
Points
0
anyone want to help sort out a formula that needs to have several logic areas embedded into it to return a result? my brain is melting today:shocked: I have attached a sheet with ???Help where i need a formula to look up from the Grid and return a result. any geniuses?:cool2:
 

Attachments

  • example feb 13.xlsx
    17.6 KB · Views: 18
@Herbds

Why do our your answers look the same? Spamming?
 
Explain how you get 15.24% in:
3 DEPT Tier 2 15.24%

and how do you want the amount calculated (a simple sum, in this line say: 270,000 ?)
 
@ Pecoflyer
Don't see your answer, but would be pleased to compare notes.
 
@Herbds

Typo, I meant your answers, they're the same all over the forum
 
Back
Top