directing cell contents dependent on its value

[Debi]

How do i write a formula that will redirect a cell contents to one of two
cells.
One for if its less than 36 and one if its over 36. I am using it as an
electronic clockcard monitoring system and need to transfer a debit or a
credit balance to the sheet for the next week.

 

[ozgrid.com]

=IF(AND(ISNUMBER(A1),A1>36),A2,IF(AND(ISNUMBER(A1),A1<36),A3,0))

 

[Mike H]

Hi,

Excel formula don't work like that they can't 'Push' values to another cell,
all they can do is 'pull' values in. You have to put a formula in the cells
where you want the values to appear.

For example In b1 we can have the formula

=IF(A1<100,A1,"")

and in C1

=IF(A1>=100,A1,"")


So when we type 99 in a1 it appears in b1. If we type 100 in a1 it appears
in C1
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.