=IF(Values_Entered???

  • Thread starter Thread starter medicenpringles
  • Start date Start date
M

medicenpringles

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
 
=IF(COUNTA(A1:N1_=14,"do it","")

--

HTH

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Values_Entered? 1
how do i create funciton values_entered in excel 1
Loan Amortization Schedule Template from Business Financial Plng. 5
VBA set thick borders around non empty cells in range 0
Unknown IF function parameter on amortization schedule 1
wildly varying execution speeds - is it the code? 3
any ideas why execution speed varies? 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top