conditional formula
 

Hi there!
I would like Excel to perform to different actions if the condition is
true, is it possible?

In fact if the condition is true i d like both, the word "COMMANDE" to
be written in a cell and a number to be written in an another cell.

Can you help me to write the formula, here what i have:
=IF(D7<(40*13+270);"COMMANDE";"")
I d like also the number 570 to be written in Q7 (or better in D7+13
cells on the right= Q7, do u have also the answer to that?)

Thanks,

JuPiter


--
Jupiter
------------------------------------------------------------------------
Jupiter's Profile: http://www.excelforum.com/member.php...o&userid=34151
View this thread: http://www.excelforum.com/showthread...hreadid=539194

conditional formula
 

A formula cannot act upon the contents of another cell.
You will have to enter into Q7:
=IF(D7<(40*13+270);570;"")

If you really want the condition to act upon 2 cells, you will need some VBA
macro code.

HTH
--
AP

"Jupiter" a écrit
dans le message de news:
...

Hi there!
I would like Excel to perform to different actions if the condition is
true, is it possible?

In fact if the condition is true i d like both, the word "COMMANDE" to
be written in a cell and a number to be written in an another cell.

Can you help me to write the formula, here what i have:
=IF(D7<(40*13+270);"COMMANDE";"")
I d like also the number 570 to be written in Q7 (or better in D7+13
cells on the right= Q7, do u have also the answer to that?)

Thanks,

JuPiter


--
Jupiter
------------------------------------------------------------------------
Jupiter's Profile:
http://www.excelforum.com/member.php...o&userid=34151
View this thread: http://www.excelforum.com/showthread...hreadid=539194

conditional formula
 

Yeah i did that! I think i ll keep it this way it ll be easier, thxs.
Do u know by any chance if Q7 can be written as C7+13 (cells on the
right)...
Thanks again!
JuPiter


--
Jupiter
------------------------------------------------------------------------
Jupiter's Profile: http://www.excelforum.com/member.php...o&userid=34151
View this thread: http://www.excelforum.com/showthread...hreadid=539194

conditional formula
 

use OFFSET(C17,0,13)

HTH
--
AP

"Jupiter" a écrit
dans le message de news:
...

Yeah i did that! I think i ll keep it this way it ll be easier, thxs.
Do u know by any chance if Q7 can be written as C7+13 (cells on the
right)...
Thanks again!
JuPiter


--
Jupiter
------------------------------------------------------------------------
Jupiter's Profile:
http://www.excelforum.com/member.php...o&userid=34151
View this thread: http://www.excelforum.com/showthread...hreadid=539194