Yes, you can use calculated columns. If you are using licensed version, i am sending you working demo.

Hi, I'm looking to do something similar. I need to add the values of column A,B,C,D for a total in column E.

Could you send the demo to me as well?

Thanks

I've emailed you demo. It is currently supported with licensed version.

Could I also have the demo.
Thank you

Emailed you demo. Also linking it at pastebin for reference.
It uses custom events, that are supported in full version.

http://pastebin.com/EdStBNbD

Dear Abu, Please send me the same demo. I also want to implement the formula as in excel sheet. I sent you a mail also. Thank you in advance! With warm regards, Krishna

Sharing demo code here: http://pastebin.com/EdStBNbD

See: $d["diff"] = 200-$d["client_id"];