cell shows status based on multiple IF statements????

[jonnywakey]

Picture2.jpg

Hi I have spreadsheet as shown in attached image and am having trouble with formatting the status cell (D6)

It should work as follows:-

If F6 is equal or greater than 1 "No Sale"
If I6 is not blank then "In-WIP" and it ovewrites "No Sale"
If K6 is greater than 0 "Sale" and overwrites "No Sale"

Cant get this to format, is there a way to do this?

Thanks

Jonny

[Cutter]

Maybe:

=IF(K6<>"","Sale",IF(I6<>"","In-WIP",IF(F6>=1,"No Sale","")))