-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
cpi
-
S
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...- Superhick
- Thread
- cpi formula simplify frequency of occurrence
- Replies: 2
- Forum: Excel Questions
-
C
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...- chandrashekar
- Thread
- chandru cpi cpi1 formula formula1need
- Replies: 4
- Forum: Excel Questions
-
R
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 -...- robynl
- Thread
- 3.1% add cpi gst rent
- Replies: 4
- Forum: Excel Questions
