Applying minimum cell value

G

Guest

Having difficulty with nested functions
A1 X B2 = X
If X = > 35, I want cell to show true value
if X = <35, I want cell to show 35
Most of nested function is working, but when less than 35, a higher value
(60) is showing, it must be adding some other value to the total !
Any suggestions please ??
=SUM((IF(U24=0,(P24/1000)*5+IF((((P24/1000)*5)<35),35),(P24/1000)*3.1)))
 
A

Arvi Laanemets

Hi

MAX(5*P24/1000,35)
returns at least 35 - put this expression into your formula
 

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

Similar Threads

Formula help please 1
Nested IF & MAX Function 4
Counting Zeros in a row until encounter first non-zero value 9
vlookup and match first value greater than 4
How do I display a minimum or cell value? 2
Where to begin??? 8
how do I use array references in VLOOKUP()? 2
How to establish a maximum and minimum value to a cell 2

Top