here are the formulas I have now (work fine)
=IF(LEN(B11)>0,B11-1.5,"")
I need to add...if total is greater than the number I put in E5(E5 will change) leave blank...if not...countinue formula
not sure if I need to add a countif or what....
next...
=IF(LEN(A11)>0,A11+7,"")
need to add....if B12 is blank....leave blank...if not continue formula
last one....
=$D$11
need to add...if total of colum is greater than the number in H5 leave blank, if not continue formula.
I am thinking it will be something like
IF(LEN(D$11$: D63>H5,"",=$D$11)
/\ space added to avoid
but nothing I am trying is working.....All this is a little over my head anyway...
All my formulas are working now....but I am having trouble when I add multiple factors....
Thanks in adanvce for the help...
Reply With Quote