MS Excel forumla help needed....

[damiongage]

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...

[damiongage]

Sorry

Could a Mod move this to the computer forum...

Thanks

[Tock]

Can you write a short macro to do this?

I used to write Lotus macros all the time . . . never bothered to convert everything to Excel when the rest of the company had it on their servers, because the Excel macro language lacked a few crucial functions that Lotus 123 had. But this should be fairly simple . . .

You could pick two cells not used in your spreadsheet, like C1 and D1. Then have the macro copy the contents of whatever cells you want to compare to C1 and D1. Then have the macro compare C1 and D1, and then process the cells in question accordingly.

[wilson9d]

its not as complicated as you are making it is was going to put in the way to do but i work all day already. just simplify what your doing.