Hi Friends ,
I am trying to calculate value in a cell as soon as other cell of the same row becomes non-blank. For example :
Once the value in cell G1 > 0 then system should auto calculate the value in coressponding cell of H i.e H1.
Similarly once G2> 0 then value of H2 should be calculated & so on.
Here Column G and H are fixed only rows will vary.
While calculating the value of H1 ,
if B2 = "TEXT1" then
H1 = G1 * 0.345
If B2 = "TEXT2" then
H1 = G1 * 0.789
Similarlly value of H2 is to be calculated once G2>0 & so on.
Here Cell B2 is fixed( it have drop down value TEXT1 , TEXT2) , means for all the cells of column H , we will be referring value of cell B2 only.
Please help.
Thanks in advance.
Regards
Achal
I am trying to calculate value in a cell as soon as other cell of the same row becomes non-blank. For example :
Once the value in cell G1 > 0 then system should auto calculate the value in coressponding cell of H i.e H1.
Similarly once G2> 0 then value of H2 should be calculated & so on.
Here Column G and H are fixed only rows will vary.
While calculating the value of H1 ,
if B2 = "TEXT1" then
H1 = G1 * 0.345
If B2 = "TEXT2" then
H1 = G1 * 0.789
Similarlly value of H2 is to be calculated once G2>0 & so on.
Here Cell B2 is fixed( it have drop down value TEXT1 , TEXT2) , means for all the cells of column H , we will be referring value of cell B2 only.
Please help.
Thanks in advance.
Regards
Achal
Last edited: