Formula

W

walkerT

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!
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top