ExcelBanter - If cell equals, give total of another cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If cell equals, give total of another cell (https://www.excelbanter.com/excel-discussion-misc-queries/64749-if-cell-equals-give-total-another-cell.html)

Lori Burton

If cell equals, give total of another cell

I have written a formula that looks like this:

=IF(Historical!I10="X","value(Historical!A10)","")

The true value returns "Historical!A10" rather than the value showing in the
cell. How do I fix this?
--
Lori

BekkiM

If cell equals, give total of another cell

Take the quotation marks out of the true value:

=IF(Historical!I10="X",Historical!A10,"")

"Lori Burton" wrote:

I have written a formula that looks like this:

=IF(Historical!I10="X","value(Historical!A10)","")

The true value returns "Historical!A10" rather than the value showing in the
cell. How do I fix this?
--
Lori

Lori Burton

If cell equals, give total of another cell

argh!!!! The quotes!!!

Thank you!
--
Lori

"BekkiM" wrote:

Take the quotation marks out of the true value:

=IF(Historical!I10="X",Historical!A10,"")

"Lori Burton" wrote:

I have written a formula that looks like this:

=IF(Historical!I10="X","value(Historical!A10)","")

The true value returns "Historical!A10" rather than the value showing in the
cell. How do I fix this?
--
Lori

All times are GMT +1. The time now is 07:48 AM.