General discussion

Locked

calculation in VB

By fanku ·
ws.Cells(iRow, 24).Value = Me.basic.Value
ws.Cells(iRow, 25).Value = Me.hra.Value
ws.Cells(iRow, 26).Value = Me.conv.Value
ws.Cells(iRow, 27).Value = Me.others.Value
ws.Cells(iRow, 2.Value = Me.mf.Value
ws.Cells(iRow, 29).Value = Me.pf.Value
ws.Cells(iRow, 30).Value = Me.esic.Value

ws.Cells(iRow, 31).Value = Me.gross.Value

how can i calculate this gross automatically

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by unni_kcpm In reply to calculation in VB

Dear Mr.Fanku

Did you try using "sum" function ?

Self not sure. Possibly similar to below or
some changes needed.

Collapse -

by unni_kcpm In reply to calculation in VB

Dear Mr.Fanku

Did you try using "sum" function ?
Self not sure.

Collapse -

by ChandraRam In reply to calculation in VB

Hi
I presume you mean the sum of columns 24 thru 27 as the gross... In this case, you can just put in a formula in ws.Cells(iRowm13). You will need to translate the column numbers to characters, though. For eg., 24=X, 25=Y and so on...

Hope this helps
Chandra

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums