View Full Version : CALCULATE DATA FROM 1 FIELD


nia44
12-15-2000, 12:46 PM
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.

alxj
12-16-2000, 07:34 AM
erm you could try conditional formating that would change the results colour but i am not sure about value?