• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Maximum value function

pao13

Member
Hi.
I attach my workbook. I would like a formula so that cells in column G to have a maximum value of $V5/E4*100 (for G4). Otherwise to keep their values. This is the formula now in column G: IF(MOD(ROW(),2)=0,(ROUND($V$4/E4/100*(1+IF(K3<0,Y4*10%,0)),0)),G3)

Thanks as always
 

Attachments

  • RSX DATAforum.xlsm
    199.3 KB · Views: 0
You may need to adjust the row references, but formula structure would be like:
=MIN($V$4/E4*100,IF(MOD(ROW(),2)=0,(ROUND($V$4/E4/100*(1+IF(K3<0,Y4*10%,0)),0)),G3))

This will says the result can never be greater than the bolder portion.
 
Thanks but this doesn't seem to work. For instance in G50 the maximum should be 294 (500,000/17*100) but it stays at the prior value of 362. Also, when I change the 500,000 for anything smaller the results do not change. So the MIN formula must not be working at all.
I attach the excel again.
 

Attachments

  • RSX DATA28f1.xlsm
    208.7 KB · Views: 0
500,000/17*100 is not 294. Looks like you meant to tell me you wanted to divide by 100.
=MIN($V$4/E4/100,IF(MOD(ROW(),2)=0,(ROUND($V$4/E4/100*(1+IF(K3<0,Y4*10%,0)),0)),G3))
 
Back
Top