CODEWITHSUNDEEP
google-sheets
CYBERSIX
CYBERSIX

Reputation: 377

Google Sheet Custom Formula to run automatically when another cell is populated with value

I can not get my head around how to write this formula.

I am trying to get the value of sold item and then run function that calculate the ebay fee, paypal fee and profit and display the result in theirs cells .

Can i have this function run automatically as I enter new row and as soon as value for sold is given it calculates the rest for me ?

Here is a picture of my spreed sheet if that helps

MY Google Sheet

Upvotes: 0

Views: 104

Answers (1)

a-burge
a-burge

Reputation: 1574

Write the cost function (e.g. =C2*15% in D2) so that you are happy with the calculation. Then surround that with a conditional: =IF(C2="","",[your calculation]). You can fill that formula all the way down and it will only display when a value is present in the respective row in column C.

Explanation: The C2="" part just looks to see if C2 is empty.

Upvotes: 1

Related Questions