# cpi

1. ### CPI Frequency Flag - Formula Simplication

Hi there, I want to simplify an excessively long nested IF(OR formula; can anyone help? Here is the formula: =IF(OR(I\$6=\$F15+\$H15,I\$6=\$F15+\$H15*2,I\$6=\$F15+\$H15*3,I\$6=\$F15+\$H15*4,I\$6=\$F15+\$H15*5,I\$6=\$F15+\$H15*6,I\$6=\$F15+\$H15*7,I\$6=\$F15+\$H15*8,I\$6=\$F15+\$H15*9,I\$6=\$F15+\$H15*10),1,0) I have...
2. ### Excel Formula : Duplicate Multi condition

Hello, Need formula which should check Column A and B For Ex: If CPI have both A & B then its Yes. IF CPI has only A or B then it should be No. <colgroup><col><col><col><col></colgroup><tbody> BN LDC Formula1(Need Formula) Output value CPI A Yes CPI B Yes CPI B Yes CPI1 A No...
3. ### adding consumer price index and gst to an amount

Hi I have this table and I need to add 10% GST and CPI of 3.1%. I know adding 10% to rent of 7300 equals 8030. Then I'm lost - do I need to add GST to year 2 & 3 or is this already included from year1. If need to add GST plus CPI how do I do this. I think for yearly rent I multiply by 12 -...

### 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.

### Which adblocker are you using?

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

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