Which Forumla and How do I configure in Excel?
 

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?

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 in
Cell I27

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

HTH


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=470922

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


On Mon, 26 Sep 2005 14:19:02 -0700, Ben wrote:

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?