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