Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
I have this formula entered, yet I don't have all of the data in yet. Right
now I only have data for Row 11. =IF(SUM(Data!C10:C12)-SUM(Data!AK10:AK12)=0,"",SUM(Data!T10:T12)/(SUM(Data!C10:C12)-SUM(Data!AK10:AK12))) Here is what each thing equals: C10=0, c11=95105, c12=0, t10=0, t11=219810.98, t12=0, ak10=0, ak11=103240.7, ak12=0. I want to hide the formula but keep it in the sheet until all of the data is input. Can anyone help me do this? Thanks, Kati |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
Hi,
Suppose you need ALL the data before you want the formula to display, here is one way IF(COUNTA(C10:C12,AK10:AK12,T10:T12)<9,"",IF(SUM(D ata!C10:C12)-SUM(Data!AK10:AK12)=0,"",SUM(Data!T10:T12)/(SUM(Data!C10:C12)-SUM(Data!AK10:AK12)))) If any of the necessary cells are empty, then the total cells containing anything will be <9. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "Kati" wrote: I have this formula entered, yet I don't have all of the data in yet. Right now I only have data for Row 11. =IF(SUM(Data!C10:C12)-SUM(Data!AK10:AK12)=0,"",SUM(Data!T10:T12)/(SUM(Data!C10:C12)-SUM(Data!AK10:AK12))) Here is what each thing equals: C10=0, c11=95105, c12=0, t10=0, t11=219810.98, t12=0, ak10=0, ak11=103240.7, ak12=0. I want to hide the formula but keep it in the sheet until all of the data is input. Can anyone help me do this? Thanks, Kati |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula question | Excel Discussion (Misc queries) | |||
Formula question | Excel Worksheet Functions | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Formula question | Excel Worksheet Functions | |||
IF formula question | Excel Discussion (Misc queries) |