I'm new to using the functions in Excel so i had a go at this from online resouces and cant get it to work
I am wanting the value that is displayed in cell C14 to be dependant on the value that is entered in cell I4.
If the value in I4 is 10 or less, i want the value in C14 to be blank, if I4 is greater or equal to 11, i want the value in C4 to be 8
this is what i have at the moment but it says invalid function??
=IF($I$4>=11, $C14, "8")-IF($I$4<=10, $C14, "")
hope you can help!
Bookmarks