formula to multiply a cell with word with a cell containing number

Hello Dear All,

Great to Join your Group and Thread. Thank you

Ive been trying to get a formula to work where on a sheet i have the following argument.

if a cell Brings a word (example Mediterranean) then i would like to have it multiply by a cell containing Euro value and then the result value to multiply by another cell containing number of days.

below locations use Euro cell (D4)
mediterranean
North Europe
UAE

below locations use Dollar value cell (D5)
Brazil
Argentina
USA
Caribbean
South Africa
China

so if cell H12=Mediterranean then Multiply by D4 and then multiply by cell G12

Is it possible to pull a formula like that??

i really appreciate and thank you so much guys.

Stelios

Hello BMV,

Thanks so much for your help...super awesome....
the value is returning Zero. cant figure out why... value returned should be 1000 Euro

thanks So much for your amazing help

SteliosMSC i think short example in the Excel file could help. Read the yellow banner on the top of screen.

Ok BMV....pls hold....thanks a million

here is a word document with Screenshot Dear BMV
hope attachment is there..

thanks

So if i may just add that in Cell H12 only when i choose a location from the drop down list should calculate the amount based on days onboard.
can the result also display the currency symbol based if it was Euro or Dollar??

thanks so much for your patience and help. much appreciated. you ROCK.

stelios

Dear BMV here is a short excel maybe can help....
thanks

stelios

SteliosMSC, it's not Excel but picture.

Here it is Dear BMV ...sorry forgot to attach excel.

thanks Stelios

Dearest BMV,

Thanks a million...It works, but if Cells with location (i.e Meditteranean) is left empty it still calculates the amount. was wondering if it could ONLY calculate if box has a name. if location cells empty not to perform the calculation. is that possible??

you are a star. thanks so much,

life saver,
stelios

Does this work for you?

OH WOW.....
what can i say apart from super great Job!!! Thanks BMV

you are a life saver..... super well done. VLookup works much better.

cant thank you enough


stelios

Do you mean me? Am not BMV but you're welcome!

Oh gosh....sorry been caught up with work..... sorry dear Izzii0x.

SUper thanks

stelios

Izzii0x - did you create conditional format?

hello Team,

hope you are all super well.

is there a formula where we can have the rank column check how many example IT Manager have which score in english test column?

so 2 IT Managers may have 2 different score? can we have this calculated??

thanks a million
attached the file.....