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

Try this:

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

--
Biff
Microsoft Excel MVP


"Debsdad" wrote in message
...
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" wrote in message
...
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


Replace @mailinator.com with @tiscali.co.uk


"T. Valko" wrote in message
...
Try this:

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

--
Biff
Microsoft Excel MVP


"Debsdad" wrote in message
...
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

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
--
*****
birds of the same feather flock together..



"Sandy Mann" wrote:

"T. Valko" wrote in message
...
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


Replace @mailinator.com with @tiscali.co.uk


"T. Valko" wrote in message
...
Try this:

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

--
Biff
Microsoft Excel MVP


"Debsdad" wrote in message
...
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

"driller" wrote in message
...

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


Replace @mailinator.com with @tiscali.co.uk

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

Sandy Mann wrote:
<<snipped
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


Replace @mailinator.com with @tiscali.co.uk

--

Dave Peterson

Resistance is futile. You will be assimilated.

--
Biff
Microsoft Excel MVP


"Dave Peterson" wrote in message
...
It's a wonderful club. Glad to see you've joined us!

Sandy Mann wrote:
<<snipped
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


Replace @mailinator.com with @tiscali.co.uk

--

Dave Peterson