Thread: Nested Formula?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cwilliams cwilliams is offline
external usenet poster
 
Posts: 17
Default Nested Formula?

I am trying to create a formula and I am stuck.

For example:

If cell A1 is €œ240€ then use the rates from the €œRates!€ sheet cells
A1!:B11!, If cell A1 is €œ600€ then use the rates from the €œRates!€ sheet
cells C1!:D11!

All of this depends on what is in cell A2

The formula I used was:

IF$A1=240,IF($A20,VLOOKUP($G9,Rates!$A$1:$B$11,2) ),$A1=600,if($A20,vlookup($G9,rates!$C$1:$D$11,0) ))

Is it possible to write a formula like this? I just keep getting error
messages. Any suggestions would be greatly appreciated