Can someone tell me what is wrong with my formula

[carrguy01]

Here is the formula that i trying to make but i cant figure it out. The cells are ar4 and ar5 these number change when i run my formula. In the formula that i am creating goes in ar6. here is the formula.
=if(ar5<=then,32,40)
the second = is for less then or equal to

 

[anandvarma]

why you have used then in the formula, either it has to be string, number or reference

try one of these

=if(ar5<="then",32,40)
or
=if(ar5<=ar4,32,40)

 

[jeffreybrown]

=if(ar5<=then,32,40)

What do you want to do?

=if(ar5<=ar4,32,40)

This would be, if ar5 is less than or equal to ar4, then 32 or else 40.

 

[carrguy01]

I will give you a more visual look at what i am looking at

cell ar4=p18 (this is a number that will change all the time)
cell ar5=o34 (agian this number changes all the time )
in ar6 i need a formula that has that changes evertime if cell ar4 is less then 32 then the response is 0
If cell ar4 is between 32 and 40 and cell ar5 is more then 40 then whatever that value is example cell ar5 is 45 then cell ar6 has to be 45 as well. If Ar4 is over 32 and ar5 is 40 then ar6 is to stay 40

 

[carrguy01]

lots of looks at my question but response sense i reposted my question. Can this be done

 

[bebo021999]

I am so confused with your explanation. Anyway, I try to build base on your Info:

AR6 = IF(AR4<32,0,IF(AR5=40,40,IF(AR4<40,IF(AR5>40,AR5,"What 1"),"What 2")))

In which you may miss some criateria
What 1: AR6 = ? if 32<=AR4<40 and AR5 < 40?
What 2: AR6 = ? if AR4>=40?

 

[villy]

I hope this could help based on my analysis:

[AR6]=IF(AR4<32,0,IF(AR5>=40,D3,IF(AND(AR4>=32,AR4<40),AR4,AR5))) ---------->OLD

[AR6]=IF(AR4<32,0,IF(AR5>=40,AR5,IF(AND(AR4>=32,AR4<40),AR4,0))) ------------>NEW

Note: This is true in all condition

Thanks

_________
"villy_voo"

 

[bebo021999]

I hope this could help based on my analysis:

[AR6]=IF(AR4<32,0,IF(AR5>=40,AR5,IF(AND(AR4>=32,AR4<40),AR4,AR5)))

Thanks

_________
"villy_voo"

String in RED can be moved, because it is placed in false condition (If (AR4<32,0,false) => back to my suggestion last post.

 

[villy]

bebo021999,

I have tried that and it works for me in all condition.

Thanks

 

[bebo021999]

bebo021999,

I have tried that and it works for me in all condition.

Thanks

Sure it does, but sometime we need to shorten the formular, it is useful in case of large data.