Which Forumla and How do I configure in Excel?

B

Ben

Being a bit of a novice at certain formula functions in Excel, I am unsure
how to configure a few cells.

Basically, this is the scenario,

I want Cell I27 to look at Cell B26 to find out if the value is more or less
than 40 Euros. If it is 40 Euro's or more then I want it to take the value
of 4 Euro's and multiply by 100. If it is less than 40 Euro's then I want it
to take the value of 2 Euro's and multiply by 100.

I don't think an IF Forumla will work and not sure if a VLOOKUP will be right.

Any suggestions?
 
C

Casey

Ben,
Where are you getting the value of 4 Euros from?
Assuming that the current value of a Euro is in Cell A1 try this i
Cell I27

IF(B26>=40(A1),(4(A1))*100,(2(A1)*100)

HT
 
G

Gord Dibben

Ben

=IF(B26>=40,400,200)

Or if the value of a Euro is in a cell, say in B25

=IF(B26>=40*B25,400*B25,200*B25)


Gord Dibben Excel MVP
 
Top