So I have a table whereby if a cell contains a certain number it will perform a specific calculation based on this certain number.
In this case (attached), if B2 contains an 11 I need C2 to perform A2/1.5. And if it contains a 10 I need C2 to perform A2/1.45. Any other number should cause C2 to remain blank. Ideally I need this calculation in the same formula.
Is this possible?
Bookmarks