Your solution please

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Sirs,

Please give me how can you please help me the formula/adivce for the followings

In a Row No. 1, cell A to H different numbers are typed
now can u tell me the formula/way for
IF the H cell value is lesser than G cell the same value to be shown on H
cell of ron No.10
A B C D E F G H
2 4 5 6 6 5 6 5 ROW NO 1


5 ROW NO 10

Where as
else the H value is greater than G the H cell value to be shown on row not 15
A B C D E F G H
2 4 5 6 6 5 6 7 ROW NO 1


7 ROW NO. 15
I request your valuable advice please
thanking you

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
do you have only row of data

in H10 copy this formula

=IF(H1<G1,H1,"")

in H15 copy this formula

=IF(H1>G1,H1,"")

what happens if H1=G1???

modify the formula to suit you.