conditional formula

[Jupiter]

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

 

[Ardus Petus]

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

 

[Jupiter]

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

 

[Ardus Petus]

use OFFSET(C17,0,13)

HTH