Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
=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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i create funciton values_entered in excel | Excel Worksheet Functions |