Your solution please

Closed
ravichristy - Dec 5, 2009 at 09:50 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 6, 2009 at 12:01 AM
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 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 6, 2009 at 12:01 AM
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.
0