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