IF Function Question
Hi,
Am Thu, 19 Jul 2012 16:30:21 +0000 schrieb koeio:
I Would like to know if it is possible to do something like this using
IF:
From this:
=IF(A1*A2100;A1*A2;0)
To something like this:
=IF(A1*A2100;ResultFromTest;0)
Where "ResultFromTest" variable will be the result from the test
"A1*A2", this way removing code redundancy.
e.g. enter =A1*A2 in G1, select Name manager and give G1 the name
ResultFromTest. Then you can use the name in the formula. But you don't
have to do it with an If-Statement. Try:
=(A1*A2100)*ResultFromTest
or
=(ResultFromTest100)*ResultFromTest
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|