Forum Discussion

Copper Contributor

Feb 21, 2019

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)"...

Formulas and Functions

office 365

Twifoo

Silver Contributor

Feb 22, 2019

Seemingly, this is the formula you need:
=IF(AND(G18<=10,G18>5),
G13,
G14)