#1
|
|||
|
|||
help with "IF and" please
So I have a work book with two sheets, sheet 1 = "work sheet" sheet 2 = "Data" I am trying to get the following formula to work....... =IF(and(A8="5"",(A10=".032"",Data!F5,"")))*C10 cell A8 contains a drop down list validated by the data sheet, as does cell A10, cell F5 on the data sheet contains a dollar amount. the goal is to pick from A8 a value and also use a value from A10 to multiply the value in F5 by the value in C10 I have attached the workbook (the formula in G8 works great) |
#2
|
|||
|
|||
help with "IF and" please
Take a look here
|
#3
|
|||
|
|||
yes that works just great ..thank you I guess I didnt have enough coffee to get the "and" part right....Also great idea to use a number format instead of the way I had it...
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Error: "Changes made were lost...reconnect with server", when switching "from" field | randhurrle | Outlook | 2 | 02-25-2015 06:51 PM |
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas | jocke321 | Word VBA | 2 | 12-10-2014 11:27 AM |
When composing an e-mail how do I add "Page Layout" and "View" tabs to the ribbon | CensorTilSin | Outlook | 1 | 12-11-2013 12:05 PM |
How to edit the "Format" and the "show level" of an EXISTING table of content? | Jamal NUMAN | Word | 2 | 08-14-2011 10:46 AM |
How to choose a "List" for certain "Heading" from "Modify" tool? | Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |