=IF(Values_Entered???
 

on the Loan Amortization Schedule template that you can download fro
Microsoft, there is a property in a cell that say
*=IF(Values_Entered,Number_of_Payments,"")*.

i would like to create a cell like this that only shows the contents o
another if there are values in all of the cells specified.

in other words, i have 14 cells, all of which the user inputs data, an
i don't want the total of all these cells to be displayed until all o
the user's cells contain data.

thanks in advance,
stephe

--
medicenpringle
-----------------------------------------------------------------------
medicenpringles's Profile: http://www.excelforum.com/member.php...fo&userid=1645
View this thread: http://www.excelforum.com/showthread.php?threadid=31498

=IF(Values_Entered???
 

=IF(COUNTA(A1:N1_=14,"do it","")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"medicenpringles" wrote in
message ...

on the Loan Amortization Schedule template that you can download from
Microsoft, there is a property in a cell that says
*=IF(Values_Entered,Number_of_Payments,"")*.

i would like to create a cell like this that only shows the contents of
another if there are values in all of the cells specified.

in other words, i have 14 cells, all of which the user inputs data, and
i don't want the total of all these cells to be displayed until all of
the user's cells contain data.

thanks in advance,
stephen


--
medicenpringles
------------------------------------------------------------------------
medicenpringles's Profile:
http://www.excelforum.com/member.php...o&userid=16458
View this thread: http://www.excelforum.com/showthread...hreadid=314985