Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
spreadsheet
hi i am new to this
I have a simple spreadsheet for accounts I need to find a formula that says if in a1 a number from 1 to 6 is entered the value of another cell adds to a column marked 1 to 6 thanks anyone who helps |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
spreadsheet
the value of another cell adds to a column marked 1 to 6
Your question is very unclear, particularly the above part. However in general a formula that is to return one value if cell A1 holds a value from 1 to 6 and something else otherwise would look like this: =IF(AND(A1=1,A1<=6),TRUE,FALSE) You would just have to replace the TRUE and FALSE parts with the formulas or values you want returned to the cell this formula is entered in. -- Jim "paressanne" wrote in message ... | hi i am new to this | I have a simple spreadsheet for accounts | I need to find a formula that says if in a1 a number from 1 to 6 is entered | the value of another cell adds to a column marked 1 to 6 | thanks anyone who helps |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link a local spreadsheet to a network shared spreadsheet | Setting up and Configuration of Excel | |||
How do I copy spreadsheet data as shown to another spreadsheet? | Excel Discussion (Misc queries) | |||
In Excel I want to copy text from spreadsheet to spreadsheet | Excel Worksheet Functions | |||
conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet | Excel Discussion (Misc queries) | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) |