Hi

I have been wrecking my brains to try and achieve this. I have a formula at present which does a calculation if a cell is not blank but I also want to cap the calculation even the calculation is greater than another cell.



=IF(S26 = "", "", (S26*Q26)) - (current formula)

any ideas?

Could you explain this please?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

IF(S26 = "", "", (S26*Q26) IF T26 > J26 = J26)

didn't work

what I mean if cell S26 is blank return blank of if not blank proceed with calculation but if calculation equals to greater then cell J26 just cap amount to that of J26

Like this?
=IF(S26 = "", "",MIN(S26*Q26,J26))

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

worked like a dream thanks so much!

You're welcome
And BTW please do not quote entire posts unnecessarily. Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

It's always best to start a new thread when you have a new question, eventually adding links to any relevant thread.
This will give you a better chance to get an answer.
I created a new thread for you
https://www.msofficeforums.com/excel...tml#post131608

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post