Forum Discussion

sandraz869289's avatar
sandraz869289
Copper Contributor
Feb 21, 2023
Solved

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

Resources