IF formula help

D

Dinesh

Hi,

I am looking for a IF statement (?) where it write the statement as stated
below.


From To Statement as formula
A B C D A B C D
10 10
From A to B
11 11
From B to A
12 12
From D to C


Thanks to advise.

Dinesh
 
D

Dinesh

Hi Dave,

Here how it goes.

Col A row 1 has title "From"
Col E row 1 has a title "To"
Row 2 - Col A thru D has peoples name A, B, C, D
Row 2 - Col E thru H has same peoples name A, B, C, D
Row 3 - Col A has $10 (person A)
Row 3 - Col F has $10 (person B)
Row 3 - Col I should have formula (I am thinking IF formula ?) where the
result should returns "From A to B". meaning person A has $ 10 which needs to
be transfer to perosn "B".

Row 4 Col B (person B) and Col E (person A) has $11
Row 4 Col I should return the result "From B to A".

I hope it's clear.

Thanks.

Dinesh Shah
 
Top