Formula Help

[Sue144]

I'm trying to create a formula that will return either a text message if value is less than zero or calculate a figure if the value is positive. I can do it in separate cells but I wanted it to return either a "No Text" or the value due.

So based on the salary figure in cell C7 less the threshold shown in cell C11 in cell C13 I want to either have No NI or the amount due, the no nI in row 14 also doesn't work if the salary is over the value in row 11 I'm sure there is a simple solution and I'm just being really stupid

Oncost Calculation.xlsx
	N
19
Sheet1

 

[Kerryx]

Just guessing here it is something like this!

Book1
	C
7	1000
8
9
10
11	1001
12
13	No Text
Sheet1

Cell Formulas
Range	Formula
C13	C13	=IF(C7-C11<0,"No Text",C7-C11)