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 rmunday
You nearly had it. It would look like =IF(G18>10, $G$14, IF(G18>5, $G$13, $G$14))
You don't need to add in " " as it will make it text as Sergei has said, and you don't need to use = when nesting fucntions.
EDIT: What Twifoo has put is also correct but does not need nesting.
One a side note, this forum is a great place to learn about Excel from people like SergeiBaklan and our other experts. Well worth a browse and check in every now and again!
Cheers
Damien