c15

Hello In C6 I put 3. In C15 I put: =IF($C$14:C14<=C6,0) However the C15 says FALSE iinstead of 0! Why that? It's so confusing!

I have cost range as shown below C1 till C15. However, I want to a button which can change the Cost code randomly however amount range should be in same place. For example, if C1 assigned to 0 to 3Lacs as below, it should change as C12(or any random) as 0 to 3 Lacs when I click that button...

Hello, I have 10 identical sheets- 9 sheets are having data and the 10th one is master summing all values from sheet 1 to sheet 9. I'm trying to sum the product of values in c9 and c15 in every 9 sheets and showing the sum in cell c15 in the master sheet. Appreciate help for the formula...

Hi All, Couple of things i havent been able to get sorted out yet, first if C15 is 50 or less add 1 to D15 and 2 to E15, or if C15 is =51 <75 add 1 to D15 and 3 to E15, etc.. 2nd if O2 or R2 is Purple,Orange,teal or aqua and H2 is red add(Sheet2-C15 to sheet1-F17),green add(Sheet2-D15 to...

I swear I've done this before, but it's not working today and I cannot figure out why. In the table below, I have assigned the name "Header" to row 6 and "Footer" to row 12. In C12, I calculate the average of the ratings in C7:C11. In C13, I try to do the same thing, but using the named...