Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Maybe I need a if/then statement
I have row D that needs to be over 4.00% to be counted 33%
Row H that needs to be a positive number to be counted 33% Row L that needs to be a positive number to be counted 33% and the sum of all three rows add in row P. The range could be 0%, 33%, 66%, or 100% I hope this makes since. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Maybe I need a if/then statement
I also did not want to create any rows that contained any information other
than row P. "JBG" wrote: I have row D that needs to be over 4.00% to be counted 33% Row H that needs to be a positive number to be counted 33% Row L that needs to be a positive number to be counted 33% and the sum of all three rows add in row P. The range could be 0%, 33%, 66%, or 100% I hope this makes since. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Maybe I need a if/then statement
You are getting rows and columns mixed up - columns are referred to by
letter. Assuming you want to start this on row 2, then try this in P2: =(D20.04)/3 + (H20)/3 + (L20)/3 Format the cell as percentage, then copy down as required. Hope this helps. Pete On Feb 28, 11:10*pm, JBG wrote: I also did not want to create any rows that contained any information other than row P. "JBG" wrote: I have row D that needs to be over 4.00% to be counted 33% Row H that needs to be a positive number to be counted 33% Row L that needs to be a positive number to be counted 33% and the sum of all three rows add in row P. *The range could be 0%, 33%, 66%, or 100% *I hope this makes since.- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If statement | Excel Discussion (Misc queries) | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |