Forum Discussion
Nested IF function error
I am a Business student taking a class to refresh my knowledge of spreadsheets and using Excel. My school uses Office 365. The function I have is this: =IF(G18>10,$G$14,"=IF(G18>5,$G$13,$G$14)"...
Hi,
You have no second IF in your formula. You have only one IF which returns for FALSE condition returns some text. You have the word "IF" within that text, together with other text, but that's not a formula IF.