Formula/Calculations Assistances

J

Jhazon

New member
Joined
Nov 15, 2015
Messages
2
Reaction score
0
Points
0
Location
Canada
I need some assistance with this excel file and work the calculations....


I need to make an easy, auto calculation of the following:


(Effective Rate) - (Tech Rate corresponding with second tab) = A

then A / (Effective Rate) = % Gross



Any assistance would be greatly appreciated!
 

Attachments

  • ELR-November2015.xls
    36.5 KB · Views: 20
In cell G10, try this:

Code: 
=IFERROR((E10-VLOOKUP(VALUE(F10),'Tech Rates'!$B$2:$C$7,2,0))/E10,"")

Autofill down.

Cheers,
 
Ah! CheshireCate! This is great! Many many thanks!!
Just a little adjustment to the decimal point and font size and it was perfect! This saves me so much time!
 
You must log in or register to reply here.
Back
Top