Formula
 

Example:

CELL B13 = 188370
CELL C13 = 349986
CELL D13 = 1.5355*C13

I need a formula that goes in CELL D13 that will use the current calculation
unless it goes above 150% of cell B13, if it does go above the 150% it needs
to use 150%*B13

ANY HELP IS GREATLY APPRECIATED!

Formula
 

=IF(C13*1.53551.5*C13,B13*1.5,C13*1.5355)

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"walkerT" wrote:

Example:

CELL B13 = 188370
CELL C13 = 349986
CELL D13 = 1.5355*C13

I need a formula that goes in CELL D13 that will use the current calculation
unless it goes above 150% of cell B13, if it does go above the 150% it needs
to use 150%*B13

ANY HELP IS GREATLY APPRECIATED!

Formula
 

I think that Dave has a typo:

=IF(C13*1.53551.5*B13,B13*1.5,C13*1.5355)

An alternative:

=MIN(B13*1.5,C13*1.5355)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Dave F" wrote in message
...
=IF(C13*1.53551.5*C13,B13*1.5,C13*1.5355)

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"walkerT" wrote:

Example:

CELL B13 = 188370
CELL C13 = 349986
CELL D13 = 1.5355*C13

I need a formula that goes in CELL D13 that will use the current
calculation
unless it goes above 150% of cell B13, if it does go above the 150% it
needs
to use 150%*B13

ANY HELP IS GREATLY APPRECIATED!