maximum #

  • Thread starter Thread starter Neuther
  • Start date Start date
N

Neuther

so i have a drop down box and one of my cells is refranced to it so i
goes 1, 2, 3.

so if it's 2 or 3 i want one of my cells to be 3 i set up a lookup t
get that done but if it's 1 i want it to refrance another cell sa
=main!e3 but this is a changing number and i want it to max out at 4
is this possible

so what i have on my sheet is

=VLOOKUP(A55,Lookup!U2:w4,3,FALSE)

{a55 is my cell that is refrances my drop down box}

then in cells u2:x4 i have this

U V W
____________________

2] 1 4 =main!e3
3] 2 3 3
4] 3 3 3

but i want w2 to max out at 4

is this possible? can i do this
 
Hi
not quite sure I understood you but maybe change the entry in w2 to
=MIN(manin!e3,4)
 
Back
Top