Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dependent "If" formulas
An "IF" formula tests the result of a calculation and inserts a text
description for how to proceed depending upon the result. How could I write a formula in an adjacent row that would provide additional instructions based upon the first result - without having to retype the entire text in the second formula) Here is the example: FIRST IF FORMULA CONTAINED IN CELL A1: =IF(F23+G23<3000,"Itemize $"&SUM(F23+G23),"Choose lesser tax between Deduct and Credit methods") SECOND FORMULA CONTAINED IN CELL B1: =IF([What would be placed here instead of having to copy the text "Choose lesser tax between Deduct and Credit methods" from the first formula],"Lesser tax is:") Would whatever method suggested work for continued "IF" formula in adjacent cells that would provide additional instructions based upon the results of the previous "IF formula? Thank you -- MZ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dependent "If" formulas
1) I'm not I understood you - but whatever you type inside "inverted commas"
will remain in all copied formulas. 2) Usually, you will type the text in a "far away" non-used cell [such as ZZ1] and refer the formula to that cell with Fixing its address - such as: $ZZ$1 Micky "MZ" wrote: An "IF" formula tests the result of a calculation and inserts a text description for how to proceed depending upon the result. How could I write a formula in an adjacent row that would provide additional instructions based upon the first result - without having to retype the entire text in the second formula) Here is the example: FIRST IF FORMULA CONTAINED IN CELL A1: =IF(F23+G23<3000,"Itemize $"&SUM(F23+G23),"Choose lesser tax between Deduct and Credit methods") SECOND FORMULA CONTAINED IN CELL B1: =IF([What would be placed here instead of having to copy the text "Choose lesser tax between Deduct and Credit methods" from the first formula],"Lesser tax is:") Would whatever method suggested work for continued "IF" formula in adjacent cells that would provide additional instructions based upon the results of the previous "IF formula? Thank you -- MZ |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dependent "If" formulas
"MZ" wrote:
FIRST IF FORMULA CONTAINED IN CELL A1: =IF(F23+G23<3000,"Itemize $"&SUM(F23+G23),"Choose lesser tax between Deduct and Credit methods") SECOND FORMULA CONTAINED IN CELL B1: =IF([What would be placed here instead of having to copy the text "Choose lesser tax between Deduct and Credit methods" from the first formula],"Lesser tax is:") In this case, you could write: =if(left(A1,6)="choose", "Lesser tax is:", "") If the first word of the alternative results in A1 is not distinctive, more generally you might need: =if(isnumber(search("lesser",A1)), "Lesser tax is:", "") Be sure that whatever you SEARCH for is distinctive and not a substring of something that would be ambiguous. Would whatever method suggested work for continued "IF" formula in adjacent cells that would provide additional instructions based upon the results of the previous "IF formula? Yes, but if you change A1 to $A$1, it may be easier to copy, then edit the formula, if that is what you want to do. Example: =if(left($A$1,6)="choose", "Lesser tax is:", "") ----- original message ----- "MZ" wrote: An "IF" formula tests the result of a calculation and inserts a text description for how to proceed depending upon the result. How could I write a formula in an adjacent row that would provide additional instructions based upon the first result - without having to retype the entire text in the second formula) Here is the example: FIRST IF FORMULA CONTAINED IN CELL A1: =IF(F23+G23<3000,"Itemize $"&SUM(F23+G23),"Choose lesser tax between Deduct and Credit methods") SECOND FORMULA CONTAINED IN CELL B1: =IF([What would be placed here instead of having to copy the text "Choose lesser tax between Deduct and Credit methods" from the first formula],"Lesser tax is:") Would whatever method suggested work for continued "IF" formula in adjacent cells that would provide additional instructions based upon the results of the previous "IF formula? Thank you -- MZ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I link all dependent cells to a "new" independent cell?? | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
"Pulling" up dependent information from several rows to one row YI | Excel Discussion (Misc queries) | |||
Combine logical formulas "if", "and", "or" | Excel Discussion (Misc queries) | |||
Combining formulas, "and" & "or" to verify content of multiple cel | Excel Discussion (Misc queries) |