Forum Discussion
sandraz869289
Feb 21, 2023Copper Contributor
Help with a Formula in Excel
Hello, I need help on how to do a formula in excel please. I have a cell that shows the type on construction on a cabinet, either FF or EUR, I want a formula that when cell G6 is "FF", it will calculate the number in Cell J1 (for example it might say 66 in Cell J1) divided by $11.50 or if cell G6 is "EUR", it will calculate the number in Cell J1 divided by $10.50.
What it is saying... if cabinet in a EUR, take the number of cabinets and divide by $10.50 or if the cabinet is an FF, take the number of cabinets and divide by $11.50.
I hope this makes sense..
Thank you in advance!
Sandra
=J$1/IF(G6="FF",11.5,10.5)
2 Replies
Sort By
- Detlef_LewinSilver Contributor
=J$1/IF(G6="FF",11.5,10.5)
- sandraz869289Copper ContributorDetlef_Lewin, Thank you so much! It worked... 🙂