software

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 quot;COMMANDEquot; 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(D7lt;(40*13 270);quot;COMMANDEquot;;quot;quot;)
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: www.excelforum.com/member.php...oamp;userid=34151
View this thread: www.excelforum.com/showthread...hreadid=539194A formula cannot act upon the contents of another cell.
You will have to enter into Q7:
=IF(D7lt;(40*13 270);570;quot;quot;)

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

HTH
--
AP

quot;Jupiterquot; gt; a écrit
dans le message de news:
...
gt;
gt; Hi there!
gt; I would like Excel to perform to different actions if the condition is
gt; true, is it possible?
gt;
gt; In fact if the condition is true i d like both, the word quot;COMMANDEquot; to
gt; be written in a cell and a number to be written in an another cell.
gt;
gt; Can you help me to write the formula, here what i have:
gt; =IF(D7lt;(40*13 270);quot;COMMANDEquot;;quot;quot;)
gt; I d like also the number 570 to be written in Q7 (or better in D7 13
gt; cells on the right= Q7, do u have also the answer to that?)
gt;
gt; Thanks,
gt;
gt; JuPiter
gt;
gt;
gt; --
gt; Jupiter
gt; ------------------------------------------------------------------------
gt; Jupiter's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34151
gt; View this thread: www.excelforum.com/showthread...hreadid=539194
gt;

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: www.excelforum.com/member.php...oamp;userid=34151
View this thread: www.excelforum.com/showthread...hreadid=539194use OFFSET(C17,0,13)

HTH
--
AP

quot;Jupiterquot; gt; a écrit
dans le message de news:
...
gt;
gt; Yeah i did that! I think i ll keep it this way it ll be easier, thxs.
gt; Do u know by any chance if Q7 can be written as C7 13 (cells on the
gt; right)...
gt; Thanks again!
gt; JuPiter
gt;
gt;
gt; --
gt; Jupiter
gt; ------------------------------------------------------------------------
gt; Jupiter's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34151
gt; View this thread: www.excelforum.com/showthread...hreadid=539194
gt;