Simple Google Spreadsheet Formula’s, Karachi
Deal Score0
Job Posted: 02.12.2021 6:37:56
For a spreadsheet I have two simple tweaks I need to be done: – Column J: One formula that calculates the profit that has been generated on the same day of the row. So let’s say 1% was generated, I want column J to calculate automatically how much profit this 1% is from column C (start balance of the day) – Column I: format it as a percentage with two decimals. Now it’s showing a long-digit number. For example: 2.55% Conditional for both columns: If it is in profit make the background green If it’s in loss make the background red Spreadsheet: https://docs.google.com/spreadsheets/d/173dBrubsIxlXKe1-IspqDokDHmemwF2tdiiZ7cXLHg0/edit?usp=sharing