| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide the answer to an equation until all values are inputed
I am trying to hide the answer to my equation until all the values have been
put into the spreadsheet. Anyone know how to do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide the answer to an equation until all values are inputed
Say input cells are A1, A2, etc. then
=IF(OR(ISBLANK(A1),ISBLANK(A2), etc.),"",yourformula) Regards, Stefi €˛Anna€¯ ezt Ć*rta: I am trying to hide the answer to my equation until all the values have been put into the spreadsheet. Anyone know how to do this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide the answer to an equation until all values are inputed
Another option
In D1: =IF(COUNTA(A1:C1)<3,"",<yourformula) where formula precedents are A1,B1,C1 -- Max Singapore http://savefile.com/projects/236895 Downloads: 15,500, Files: 352, Subscribers: 53 xdemechanik --- "Anna" wrote: I am trying to hide the answer to my equation until all the values have been put into the spreadsheet. Anyone know how to do this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide the answer to an equation until all values are inputed
Smarter!
Stefi €˛Max€¯ ezt Ć*rta: Another option In D1: =IF(COUNTA(A1:C1)<3,"",<yourformula) where formula precedents are A1,B1,C1 -- Max Singapore http://savefile.com/projects/236895 Downloads: 15,500, Files: 352, Subscribers: 53 xdemechanik --- "Anna" wrote: I am trying to hide the answer to my equation until all the values have been put into the spreadsheet. Anyone know how to do this? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide the answer to an equation until all values are inputed
Smarter if precedents are in a contiguous range!
Stefi €˛Max€¯ ezt Ć*rta: Another option In D1: =IF(COUNTA(A1:C1)<3,"",<yourformula) where formula precedents are A1,B1,C1 -- Max Singapore http://savefile.com/projects/236895 Downloads: 15,500, Files: 352, Subscribers: 53 xdemechanik --- "Anna" wrote: I am trying to hide the answer to my equation until all the values have been put into the spreadsheet. Anyone know how to do this? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide the answer to an equation until all values are inputed
"Stefi" wrote:
Smarter if precedents are in a contiguous range! But it works even for discontiguous ranges, Stefi, eg: =IF(COUNTA(A1:C1,A3,C3:C4)<6,"",<formula) -- Max Singapore http://savefile.com/projects/236895 Downloads: 15,500, Files: 352, Subscribers: 53 xdemechanik --- |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide the answer to an equation until all values are inputed
Yes, that's true. Another idea for Anna to make still simpler the formula:
create a named range consisting of precedent cells, say "precedents", in this case the formula: =IF(COUNTA(precedents)<6,"",<formula) Stefi €˛Max€¯ ezt Ć*rta: "Stefi" wrote: Smarter if precedents are in a contiguous range! But it works even for discontiguous ranges, Stefi, eg: =IF(COUNTA(A1:C1,A3,C3:C4)<6,"",<formula) -- Max Singapore http://savefile.com/projects/236895 Downloads: 15,500, Files: 352, Subscribers: 53 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want brackets around my math equation answer? | Excel Worksheet Functions | |||
| Hide Answer in Excel | Excel Worksheet Functions | |||
| take sum of 6 different values and then * that answer by a % | New Users to Excel | |||
| Returning an answer in an if fuction between two values | Excel Worksheet Functions | |||
| how can i hide digit 0 after putting any equation | Excel Worksheet Functions | |||
Linear Mode
