CALCULATE DATA FROM 1 FIELD

nia44

New member
Local time
Today, 02:28
Joined
Dec 11, 2000
Messages
6
HOW WOULD ONE , SAY, TAKE FIELD TOTAL MEMBERS AND IF THE NUMBER WAS GREATER THAN 4 THEN PLACE THE NUMBER 3 IN THE SIZE FIELD OR IF IT WAS LESS THAN 5 AND GREATER THAN 2 PLACE A 2 IN THE SIZE FIELD OR LESS THAN 3 PLACE A 1 IN THE SIZE FIELD? ANY HELP WILL BE APPRECIATED.
 
erm you could try conditional formating that would change the results colour but i am not sure about value?
 

Users who are viewing this thread

Back
Top Bottom