Can someone help me with these basic questions please?

[excelos]

Hello!

I wrote this function but it does not work:

=IF($I$28<=D17<($I$28+7),G28,C18-$C$28*0.2)

I want the IF function to check the date at D17 to be between the date $I$28 and $I$28 + 1 week. How do I do that?

Secondly, I want to calculate the mathematical function C18-$C$28*0.2 but I want to add that in subsequent cells the term 0.8*$C$28* 0,1,2,3 etc (ie in the first cell I want to add the term 0.8*$C$28*0 and as I drag it to the cells to the right, I want it to add the term 0.8*$C$28*1, the next one 0.8*$C$28*2, the next one 0.8*$C$28*3, etc.


Any hint please?

 

[steve the fish]

Heres the first part:

=IF(AND(D17>=$I$28,D17<$I$28+7),TRUE,FALSE)

Not quite sure i know what you ask for in the 2nd part.

 

[excelos]

Heres the first part:

=IF(AND(D17>=$I$28,D17<$I$28+7),TRUE,FALSE)

Not quite sure i know what you ask for in the 2nd part.

Thanks.

For the second part, I want (for example) this:

In the first cell, calculate 100*0. In the next cell, calculate 100*1, the next 100*2 and so on. How do I express that in Excel?
I understand you may be able to do it in a different way, but I want to express a mathematical calculation that one of the terms is gradually increasing by 1, from the previous cell.

Thanks

 

[steve the fish]

How you do that depends on which way you are dragging, across or down.

Down: =100*(ROWS($A$1:A1)-1)
Across: =100*(COLUMNS($A$1:A1)-1)

 

[excelos]

How you do that depends on which way you are dragging, across or down.

Down: =100*(ROWS($A$1:A1)-1)
Across: =100*(COLUMNS($A$1:A1)-1)

Thanks that's very clever!

And can I ask how to make a formula that will generate the below sequence?

100*0, 100*1, 100*1, 100*1, 100*1 ?

Thanks!

 

[steve the fish]

=if(rows($a$1:a1)=1,0,100)