Your solution please

Closed
ravichristy - 5 Dec 2009 à 09:50
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 6 Dec 2009 à 00:01
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 14 June 2009 Status Contributor Last seen 7 August 2021 811
6 Dec 2009 à 00:01
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.