If X>= 365 and <= 1875 then y= (x/26)*15

If X > 1875 then y =(x/26)*20

Here You Go:

----------------------

If (x < 36) Then

y = 0

ElseIf (x >= 365 And x <= 1875) Then

y = (x / 26) * 15

ElseIf (x > 1875) Then

y = (x / 26) * 20

End If

thanks,

bala

Solved

Posted on 2011-04-27

Can you please provide me when the if statement that I can use in Excel to use the following logic?

If X < 365 then y= 0

If X>= 365 and <= 1875 then y= (x/26)*15

If X > 1875 then y =(x/26)*20

Regards

Dina

If X < 365 then y= 0

If X>= 365 and <= 1875 then y= (x/26)*15

If X > 1875 then y =(x/26)*20

Regards

Dina

12 Comments

If X>= 365 and <= 1875 then y= (x/26)*15

If X > 1875 then y =(x/26)*20

Here You Go:

----------------------

If (x < 36) Then

y = 0

ElseIf (x >= 365 And x <= 1875) Then

y = (x / 26) * 15

ElseIf (x > 1875) Then

y = (x / 26) * 20

End If

thanks,

bala

im actually looking for the way the IF esle is used in Excel where you have to use =IF( A1 <365,0,,,,,,,) and so on

=IF(A1 < 365;0;IF (A1<= 1875;(A1/26)*15;(A1/26)*20))

see attache file test.ods

see attache file test.ods

if so B1 formula:

=IF(A1<365,0,IF(A1<=1875,(

=IF(x<365,0,IF(AND(x>=365,

Cheers

Rob H

=IF(A1<365,0,IF(A1<=1875,(

=IF(A1<365,0,IF(A1<=1875,1

regards, barry

the way this looked and the term "statement" u used made me assume u need code.. ;)

let's assume a1 is having the value of x:

If X < 365 then y= 0

If X>= 365 and <= 1875 then y= (x/26)*15

If X > 1875 then y =(x/26)*20

=IF(A1<365,0,IF(AND(A1>=36

this will return the value to the current cell!!!!!!!!!!!!!!!!!!

let me know if it helps!!!

This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

Join the community of 500,000 technology professionals and ask your questions.

Connect with top rated Experts

**14** Experts available now in Live!