Converting to and from Named Formulas
Bob Phillips wrote:
There are probably easier ways. not easy but easier, but it would help to
see an example formula or two so that we could make a suggestion.
--
HTH
Bob Phillips
Hi Bob,
These are the key formulas that I use, there are a number of variations
(12 variations in total) on these but whatever works for these I could
apply to another:
=IF(OR(V37={"AL";"SL";"CL";"ML";"AdL";"PL";"PaL";" OL"}),$Q$41,IF(V37="TL",$Q$41,""))
=IF(OR(V29="",V30="")=TRUE,"",IF(V29V30,-SUM(V29-SUM(V30+1)),SUM(V30-V29)))
=IF(WEEKDAY(V25)=1,IF(SUM($B26:V26,AK21)=0,"",SUM( $B30:V30,AK20)),"")
I've removed the sheet names that was in all the references just so
that it's marginally easier to read. These formulas would normally be
repeated three times in a column pointing to data that is in the same
relative position. Any help on how to change them would be most
appreciated, or an easier way to update the via the named range
dialoge!
Best Regards,
CalumMurdo Kennedy
|