Help with multiple formulas

[Lawless147]

I am after some help please on the following if any of you kind people wouldn't mind.

I have this formula in a cell working fine

=IF(OR(Q27="",Q27="Yes",Q27="N/A",N27="Yes",J27="Gap",P27="Yes"),"",T27-TODAY())

but I want to add another function if possible which would be If V27=Fail, show-1000 in S27 and have this function overwrite the other commands above.
Is there a way to fit this in or do I need to go about it a different way.

Or what could be a simpler option is if V27=Fail I want this row to automatically go to the top of the spread sheet. I was going to have V27 = -1000 and then sort the spread sheet numerically but if there is a more direct way that would be better.

Any help would be much appreciated
Simon.

 

[AlanY]

which cell is this formula in?

=IF(OR(Q27="",Q27="Yes",Q27="N/A",N27="Yes",J27="Gap",P27="Yes"),"",T27-TODAY())

 

[Lawless147]

Sorry, This is S27

 

[Fluff]

How about
=IF(V27="Fail",-1000,IF(OR(Q27="",Q27="Yes",Q27="N/A",N27="Yes",J27="Gap",P27="Yes"),"",T27-TODAY()))

 

[Lawless147]

Yep that's the one.
I tried a few like that just couldn't get it right so thank you for that, much appreciated.

 

[Fluff]

Glad to help & thanks for the feedback