Formula

[Guest]

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!

 

[Guest]

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

Dave

 

[Sandy Mann]

I think that Dave has a typo:

=IF(C13*1.5355>1.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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk