View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
driller driller is offline
external usenet poster
 
Posts: 740
Default Return Text or Blank

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