View original (French)

IF Function in Excel

Phil -  
Hello,

I'm trying to create the following Excel formula:

=IF($D$67*1.0001<$C$67<$D$67*1.24;($C$67/$D$67)*1.1*$C$10;0)

It's a range, but even if the value in C67 is within the range, it's not calculating (in bold).
I'm losing it, I've been on this for almost 2 hours.
If someone can help me, I would really appreciate it, I'm getting tangled up here...

Do your best, thanks to those who know.. 
Configuration: Windows XP Firefox 3.0.5

3 answers

  1. garion28
    =IF(AND($D$67*1.0001<$C$67;$C$67<$D$67*1.24);($C$67/$D$67)*1.1*$C$10;0)
    It should be this
    --
    Are you having problems with IE8? I’ll give you THE solution, install Firefox (search on Google)
    11
    1. garion28
      hello
      $D$67*1.0001<$C$67<$D$67*1.24
      what were you trying to do there?
      wouldn't it be rather
      AND($D$67*1.0001<$C$67;$C$67<$D$67*1.24)?
      --
      Do you have problems with IE8? I have THE solution for you, install firefox (search on google)
      1
      1. Phil
        Arf Garion, thanks already for looking into it.

        I was thinking of using IF function,
        I saw that I could combine IF and AND, which seems to be what you're doing.

        Um, what would that look like with the complete GARION formula?

        I'm not sure I know where to fit what you gave me.
        Do your best, and thanks.
        1