View original (French)

IF Function in Excel

Phil -  
garion28 Posted messages 1545 Registration date   Status Member Last intervention   -
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 Posted messages 1545 Registration date   Status Member Last intervention   408
     
    =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
  2. garion28 Posted messages 1545 Registration date   Status Member Last intervention   408
     
    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
  3. 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