LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default somewhat complex if statement help PLEASE!!!!

Okay, so i have the following so far but need help with making additions

=IF(C4="salmon",Sheet1!D12)(C4="Jumbo Lump",Sheet1!D10)

Sheet1!D12 = the corresponding number that is assigned to the word salmon - this is a food costing sheet for my kitchen. My issue is creating a continuous statement, so if the same range where it says salmon is changed to "jumbo lump" then the corresponding number for jumbo lump would appear and then some.

Any help would be much appreciated. I tried using the function through insert but i have not done coding in many years.

THank you!
 
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Complex IF statement help pjcorc502 About this forum 2 October 18th 12 05:14 PM
Complex IF Statement Jonni Excel Discussion (Misc queries) 7 June 26th 09 04:09 PM
Complex IF THEN statement Greg S Excel Worksheet Functions 5 December 8th 08 11:40 PM
Complex IF STATEMENT CR3 Excel Discussion (Misc queries) 3 December 6th 07 12:32 PM
Help with complex If statement GHawkins[_2_] Excel Worksheet Functions 2 September 6th 07 10:16 PM


All times are GMT +1. The time now is 05:43 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"