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