Hey, now, steady on !! It wasn't that good !!

But thanks for feeding back.

Pete

On Mar 9, 7:18 pm, "LeslieO via OfficeKB.com" <u30884@uwe wrote:
Oh my gosh Toppers and Pete, I Love YOU!





Pete_UK wrote:
Put a dollar symbol in front of each 1014, like so:

=IF(J117="","",IF(P$1014=100000,J117*0.019+0.3,I F(P
$1014=10000,J117*0.022+0*.3,IF(P$1014=3000,J117 *0.025+0.3,IF(P
$1014=0.01,J117*0.029+0.3,)))))

That way it will not change when you copy the formula down. Have a
look in Excel Help for Absolute (and Relative) addresses/references.

Hope this helps.

Pete

Hi,

[quoted text clipped - 17 lines]
--
Message posted viahttp://www.officekb.com

--
Message posted viahttp://www.officekb.com- Hide quoted text -

- Show quoted text -