| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CAN ANYONE HELP WITH A SPECIFIC FORMULA I NEED?
here is what I need and all attempts of writing it have failed.
in cell d3 of worksheet C, I need: value of b15 of worksheet A only if cell c2 has a value of 1 worksheet A is called pricing one formula I tried: =index(if(pricing!$c$2=1, b15... or something like that.... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CAN ANYONE HELP WITH A SPECIFIC FORMULA I NEED?
Hi christine,
How about ... =IF(Pricing!$C$2=1,B15,"") HTH -- Regards, Zack Barresse, aka firefytr To email, remove NOSPAM "christine" wrote in message ... here is what I need and all attempts of writing it have failed. in cell d3 of worksheet C, I need: value of b15 of worksheet A only if cell c2 has a value of 1 worksheet A is called pricing one formula I tried: =index(if(pricing!$c$2=1, b15... or something like that.... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CAN ANYONE HELP WITH A SPECIFIC FORMULA I NEED?
On Thu, 30 Mar 2006 14:54:01 -0800, christine
wrote: here is what I need and all attempts of writing it have failed. in cell d3 of worksheet C, I need: value of b15 of worksheet A only if cell c2 has a value of 1 worksheet A is called pricing one formula I tried: =index(if(pricing!$c$2=1, b15... or something like that.... You didn't say what you wanted returned if C2 is not one. I've assumed null. =If(pricing!$c$2=1,Pricing!B15,"") HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CAN ANYONE HELP WITH A SPECIFIC FORMULA I NEED?
The formula for cell D3 of worksheet C should be
=IF(pricing!$C$2=1,pricing!B15,) if C2 does not equal 1, then the result is empty "christine" wrote: here is what I need and all attempts of writing it have failed. in cell d3 of worksheet C, I need: value of b15 of worksheet A only if cell c2 has a value of 1 worksheet A is called pricing one formula I tried: =index(if(pricing!$c$2=1, b15... or something like that.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| UDF/Formula to replace only specific | Excel Discussion (Misc queries) | |||
| Specific formula query | Excel Worksheet Functions | |||
| Need formula to add specific #'s across the top | New Users to Excel | |||
| Formula that 'contains' a specific word | Excel Worksheet Functions | |||
| i need help with finding a specific formula | Excel Discussion (Misc queries) | |||
Linear Mode
