My M/U figure is $ 45.25.
how to minimum my M/U figure to $ 70.00 when everytime i get lower then $70.00? and i dont want any changes when i get higher figure.
thanks
My M/U figure is $ 45.25.
how to minimum my M/U figure to $ 70.00 when everytime i get lower then $70.00? and i dont want any changes when i get higher figure.
thanks
Try this:
I53: =MIN(K53*I52,70)
Does that do what you want?
Ron
Ron,
theres still no changes with the function u'd gave.
weepel
Try this ...
=max(K53*I52,70)
Regards.
BenjieLop
Houston, TX
yes, thats exactly i want to know.. thanks benjie and ron for the reply.
You are welcome ... glad I can be of help.
Regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks