5.00%

  1. J

    fill in a cell if two cells meet a criteria?

    If 2 Criteria is meet then Cell = that percentage Increase. Example1 IF Cell A3= Hammer IF Cell B3= Poor Then Cell C3= 5.00% Example2 IF Cell A4= Socket IF Cell B4= Good Then Cell C4= 10.00% My Chart B5 = Socket E6 = Damaged F6 = 3.00% E7 = Poor F7 = 4.00% E8 = Fair F8 = 6.00% E9 = Good F9 =...
  2. G

    Excel formula for calculating interest due.

    I am trying to calculate interest due on a Per-Diem basis when the interest rate changed during a given time period. For example, our institution sends out $100M on 05/20/2018 and charges an interest rate of WSJ Prime (adjusting daily) on a Per-Diem Basis. We receive a payoff request for 6/30/18...
  3. W

    Need help/advice on multiple If Statements

    Happy New Year Everyone, I am trying to use an IF Statement here; however keep getting Syntax Error. Appreciate if anyone could kindly assist. Thank you =IF((K7)>=60,(K7)<80),0.02, IF(AND((K7)>=80,(K7)<100),0.035, IF(AND((K7)>=100,(K7)>=120),0.0425,0.05))) If the result is >=60%, then it...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top