LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Default Issue writing IF OR Error Formula Types

Having trouble putting a formala together.

I have the following formula which works:

Senario : $d$d = either weight or unit or unknown (of an ingredient)
e8= is a quantity number ( either in grams or units, of an ingredient. eg 100 or 1)
Raw data is in nutrition!$b$6:$g$70

The following formula works so far:

f8 ( which is the no. of calories)=if($d$d="weight",e8/100,e8)*vlookup(c8,nutrition!$b$6:$g$70,3,false)

But I also want to add to it that

If e8(quantity)=0 or blank or invalid then "qty?" should appear in the f8 cell

And not sure what to do to avoid an error in f8 if $d$d = unknown??

Am completely stuck here, need help asap.

lozzam
 
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
Format Issue DS Excel Worksheet Functions 4 October 13th 06 01:20 AM
Excel Formula Issue [email protected] Excel Discussion (Misc queries) 2 August 16th 06 11:44 PM
Memory or power issue Steven Excel Discussion (Misc queries) 1 May 10th 06 05:06 AM
Wrap Text issue jsAlpha Excel Discussion (Misc queries) 2 January 5th 06 01:56 PM
vlookup issue ( not working and im tearing my hair out) me+excel=crazy Excel Discussion (Misc queries) 6 November 19th 05 10:49 PM


All times are GMT +1. The time now is 09:00 AM.

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

About Us

"It's about Microsoft Excel"