Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 11:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"