Return Text or Blank

[Guest]

This is my formula =IF(D3+E3<C3,"REL",0), this works fine if I need to
release more work but it returns a 0 when I have enough. I would like to have
it return as "blank" (no text, no numbers) when I have enough.

Thanks
Debsdad

 

[T. Valko]

Try this:

=IF(D3+E3<C3,"REL","")

 

[Sandy Mann]

Try this:

=IF(D3+E3<C3,"REL","")

Come on Biff, leave some of the simple ones to us mere mortals <g>

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Guest]

as one of the mortals <hehehe>

may i guess that your works are D3 and E3, while *<C3* is your rest limit
for combined work...

so i guess that u need to work for both D3 and E3, before I can say that u
will have enough to rest in blank""...

try this..
=if(and(d3<>"",e3<>"",d3+e3>=c3),"","REL")
c3,d3 and e3 are numbers...
lastly I guess you need the other formula from Sandy and Sir Valko, who work
for this question, a time ago....

regards,
driller

 

[Sandy Mann]

lastly I guess you need the other formula from Sandy and Sir Valko

I didn't post a formula, I just quoted Biff's - I don't want to be accused
of plagiarism!

No wait a moment, I don't think that I have written anything original ever -
just re-cycled what I have learned here. <g>

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Dave Peterson]

It's a wonderful club. Glad to see you've joined us!

Sandy Mann wrote:

 

[T. Valko]

Resistance is futile. You will be assimilated.