Thread: if formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nigel123 Nigel123 is offline
external usenet poster
 
Posts: 7
Default if formula

Hi im wanting to set up 4 formulas in 1 cell

I have got the first part done which is

=IF(D2=0,"0",IF(D20.01<15,"7.25",IF(D2<=15,7.25,I F(D215,(D2-15)*0.29+7.25))))

However the next step is to use this formula if cell e2 matches nd16 and if
it matches nd17 it will automatically use a different formula and if it
matches nd18 it will automatically use another formula and so on so fourth
can someone help me??

cheers