IF Function in Excel
Phil
-
garion28 Posted messages 1545 Registration date Status Membre Last intervention -
garion28 Posted messages 1545 Registration date Status Membre 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..
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 réponses
=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)
It should be this
--
Are you having problems with IE8? I’ll give you THE solution, install Firefox (search on Google)
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)
$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)
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.
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.