looking for right formula

[Rosnab]

Hi Everyone,

i'm setting up sheet to include as much info as poss without needed to re type date from one sheet to another etc.

eg
if one cell has list data varification for currency EUR GBP and USD. lest say cell C3

for another column/cell (H3) i need to have formula to say if C3 is EUR or USD the show value 45.00 in h3, if GBP show 30.00

pleased to hear if anyone can help

Cheers

 

[oldbrewer]

make a look up table with the currency conversion factors...

 

[Rosnab]

the "45" and "30" are always the same, conversion rates dont apply.
just want to save re typing a lot of things that remain same

• can it be a sumif formula?? if C3 states EUR or USD then H3 is 45.00 etc

 

[oldbrewer]

=if(c3="UKP",30,45)

 

[Rosnab]

Thank You

 

[oldbrewer]

I thought it might be more complicated than that...always happy to help...