General discussion
October 1, 2003 at 10:10 AM
whatme?

Excel formula or help

by whatme? . Updated 22 years, 12 months ago

I have a list box in A43. they choose “NU” “NT”or “CA” at the beginning of each row
an ex of one row:
In cells h43:k43, the user will place an “x”.
Only those boxes (h43:k43) with an x are totalled.
If they choose A43 (NU), then the values in h43=20,i43=25,j43=30,k43=40. The total will be in L43
If they choose A43(NT), then the values change in h43=12,i43=17,j43=22,k43=28
If they choose A43(CA), then the values change in h43=10,i43=14,j43=17,k43=20

Thanks for any help

This discussion is locked

All Comments