ExcelBanter - Logical test question

stevieboy1313 wrote:
I need a formula that says, "Hey, the data entered in cell D6 is =/
50,000, so I need to copy all of Row 6 and paste it into another
worksheet". Is that possible? It seems like it would be. But I think
that the formula needs to be in D6, and not in the other worksheet.
Would I be better off to record a macro? And if so, can the IF
function be pasted into a macro?

Hi Stevie,

It is impossible that the formula is in the same cells of the input value to
check (a cell or is blank or have a formula or have an input value (number
or text, it doesn't matter...)), but you can use a formula in a different
cell to check if the value you input in a cell is greater equal or lower
than a fixed value or the value in another cell. For example you could type
this formula in E6:

=IF(D6=50000;"The value is too high for me";"OK")

Then you could also use Conditional Formatting to change the font color as
the value change.

If you want to use macros, you can use the VBA instructions:

If ... Then

or

If ... Else ... Then

or

If ... ElseIf ... Else ... Then

But you cannot obtain this instruction by the macro recorder, you have to
type yourself...

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy