Why not just

=IF(G42<=I3,IF(B42="Current",H42,0),IF(B42="EX",H4 2*7,0))

But my guess is that I3:AR3 comes into it,m you justv talk about I3.


--

HTH

Bob

"Mark D" wrote in message
...
Morning all

I am stuck with a forumula that I hope someone will be able to help with.
It's quite long winded the way I am doing it but am hoping that it may be
able to be shortened.

Column B Lines 42 - 58 has either "current" or "ex" in the cells

Column G lines 42 - 58 has a date in them

Column H lines 42 - 58 has either 1, 2, or 3 in them.

The line 3 (columns I AR have months of the year in them)

I need something in 1 formula that says
1. IF B42="Current" and G42<=I3 TAKE H42 otherwise 0
2. IF B42="EX" and G42<=I3 TAKE H42 *.7 otherwise 0

I was using a sumproduct formula but to run the same forumulas 16 times
(lines 42 - 58) seems too long, I was wondering if there was a way of
shortening it.

Many thanks for any help

If