If Function Question

Question

I had it earlier and made a change and screwed up the formula, now nothing I use is working

I need cell E27 to display a value based on the entry to Cell E25.

E25 has a drop down to choose either 'yes' or 'no'

If E25 has the drop down chosen as 'no' I need E27 to display '0'

If E25 has the drop down chosen as 'yes' I need E27 to display the value created by F27/G27.

If it matters, F27 is the sum of several cells from column f, G27 is the same (sum of cells in G)

How do I make this happen? I hope the above is clear, if not please let me know what additional info I can provide.

Answer 1

Though you have set your drop down list as "Yes" or "No", then you can use the below simple formula:

In E27:

=IFERROR(IF(E25="no",0,F27/G27),"")

in F27 to calculate several cells, try the below formula:

=SUM(single_cell1,single_cell2,.......,cell_range1,cell_range2,....)

in G27 to calculate the G column, try below formula:

=SUM(G:G)

Answer 2

Try below formula:

=IF(E25="no",0,IF(E25="yes",F27/G27,""))

If E25 is "no", formula returns zero;

If E25 is "yes", formula returns F27/G27;

For any other value in E25, formula returns a blank;

Regards,

Amit Tandon