Cell Value According Change Other Cell value

[krunal123]

(NEED THIS CONDITION)

C2= "20 ft" use 5,00,000

C2= "40 ft" use 10,00,000


Change value According "20 ft" Or "40 ft "

------------------------------Kindly Suggest Right Formula-----------------

 

[Joe4]

In D2:

=IF(C2="20 ft",500000,IF(C2="40 ft",1000000,""))

and copy down.

Note if your regional setting use semi-colons instead of colons to separate function arguments, it will look like:

=IF(C2="20 ft";500000;IF(C2="40 ft";1000000;""))

 

[Fluff]

How about

=SWITCH(C2,"20 ft",500000,"40 ft",1000000,"")

 

[Joe4]

How about

=SWITCH(C2,"20 ft",500000,"40 ft",1000000,"")

I forgot about the new SWITCH function, which makes things a little simpler.
And since it appears they are using 365, it should be available to them.

 

[Fluff]

I don't always think about, but it can make things simpler, although probably no real benefit if it's only 2 values.