formulas
I want a formula base on cell A1(start month)
this formula should only be under May in E5
--
KK
"JBeaucaire" wrote:
Try this formula in A5:
=MIN(1,A3-A4)
--
"Actually, I *am* a rocket scientist." -- JB
Your feedback is appreciated, click YES if this post helped you.
"Kay" wrote:
Cell A1 have May 5, 2006(start date)
cell A2:L2 have month from January to december
In cell A3:L3 and A4:L4 I have numbers under each months
in cell A5:L5 I have the fomula =A3-A4 I do this across to L3-L4
The only problem I need a formula to Make E5 which is under the month of may
1 or less than 1(it cannot go over 1) the other cells can be flexible
This formula should be base one cell A1 Start date.
--
KK
|