Help required in entering correct formula

Hi all, I need help in entering a correct formula based on calculations involved in another sheet. Let me begin with the sheet containing the calculations. I have some companies and ...

Formulas & Functions

Need Help

Anonymous
Dec 28, 2017
Hi Satyajeet Nayak,

- Place the below formula in cell B3 of "Adjusted Net Worth" sheet:

=IF(SUM('Unrealized Appr or Dep.'!E14:E23)>SUM('Unrealized Appr or Dep.'!F14:F23),'Unrealized Appr or Dep.'!G24,0)

- place the below formula in cell B6 of "Adjusted Net Worth" sheet:

=IF(SUM('Unrealized Appr or Dep.'!E14:E23)<SUM('Unrealized Appr or Dep.'!F14:F23),'Unrealized Appr or Dep.'!G24,0)

Hope that helps..!!

Regards,

Bala..