Yes MAX(), MIN(), very confusing for both of us isn't it? <g

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Don Guillett" wrote in message
...
That's OK., I should have said MIN instead of MAX but the help index would
have referred you to the other anyway.
--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
PLEASE do not type in all capitals. It is not considered to be good
netiquette. It is SHOUTING!

Have a look in the help index for MAX and post back if you still have
questions.

--
Don Guillett
SalesAid Software

"Zigball" wrote in message
ups.com...
HELLO GOOGLE GROUPS I HAVE A PROBLEM, I NEED TO MAKE A SPREADHEET THAT
IS BEYOND MY CAPABILITIES SO I AM ASKING FOR YOUR HELP. THIS FORMULA
THAT I NEED TO ME SEEMS COMPLEX BUT TO SOMEONE THATS OK WITH IF
STATEMENTS OR WHATEVER, MIGHT NOT HAVE A PROBLEM. OK, I WOULD LIKE TO
ACHIEVE A FORMULA THAT CALCULATES A NUMBER IN A CELL FOR INSTANCE CELL
A2 (THE ROOT NUMBER). FOR EXAMPLE I TYPE 500 INTO CELL A2 THEN IN CELL
B4 IS WHERE THE FORMULA I NEED TO FIND WILL LIVE. IN CELL B4 I WANT A
FORMULA THAT WILL MULTIPLY THE NUMBER IN A2 BY LETS SAY 5 (=A2*5) I
KNOW THAT MUCH. THE CATCH IS THAT I DO NOT WANT CELL B4 TO MULTIPLY ANY
AMOUNTS PASS 400 THAT IS IN CELL A2. SO IN CELL B4 I WANT IT TO BE
LIMITED TO MULTIPLYING ANY VALUES THAT GO PASSES 400. ALTHOUGH 500 IS
IN CELL A2 AND FORMULA STATES THAT I WANT A2 TO BE MULTIPLIED BY 5, A2
IS 500 I ONLY WANT TO MULTIPLY 400 SO THE ANSWER SHOULD BE 2000 NOT
2500. ANOTHER CATCH IS THAT I CAN NOT CHANGE THE ACTUAL NUMBER IN A2
WHICH IS FIVE HUNDRED IT MUST STAY THE SAME, IT IS REFERENCED BY OTHER
CELLS THAT ACTUALLY NEED THE ACTUAL NUMBER THATS THERE.

EXAMPLE =IF CELL A2 IS OVER OR EQUAL TO 400 THEN CELL A2 VALUE EQUALS
400 THEN MULTIPLY BY 5 IF CELL A2 IS LESS THAN 400 THEN MULTIPLY CELL
A2 ACTUAL VALUE BY 5

HOPEFULLY THIS IS OK TO UNDERSTAND THANKS IN ADVANCE!