=IF(C11=“Fairway”,IF(C12=“3i (225)”,IF(C13=“Full”,IF(C14=“100%”,C8/B45))))
Trying to get the reset of C8/B45 if the other cells have the correct information of C11=Fairway, C12=3i (225),C13=Full and C14=100%
But just get a ‘FALSE’ message appearing, its probably to many IF statements in the equation but i’m reaching the limit of my spreadsheet knowledge to fix it, hope you can help.
Cells C11 to C14 are text from a selection list, e.g. C11 has the option of Fairway or Tee. Any changes would result in cell C8 being divided by a different number.
I’ve attached the file here: