Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Excel using a constant in a cell and an equation to convert the costs to euros.?
Cell F3 =€0.91
Cell E4 = $36.00
Cell E5=$44.00
Cell E6=$5.00
Cell E7=$10.00
Cell E8=$3.00
Cell E9=$62.00 (the subtotal)
I need to use the constant in Cell F3 and an equation to convert the costs to euros in Cell F9.
3 Answers
- expletive_xomLv 77 months ago
E9 looks like you are adding the 1st 2 and subtracting the last 3 but i am not sure how you determine that.
so put this in E9
=E4+E5-E6-E7-E8
and if F3 means that .91 euro = 1 dollar then use this in F9
=E9*F3
- L.N.Lv 77 months ago
In Cell E9
=SUM(E4,E5,E6,E7,E8)
In Cell F9
=SUM(E4,E5,E6,E7,E8)/F3
or
=E9/F3
Don't know how you got $62 as the subtotal in your question.
