| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel formulas
How do you do formula's, calculations? If the condition in b15 is yes, then
the value in column d would change to whatever is in column F. If the condition is no, then there would be a 0? I'm unfamiliar with doing formula's. Thanx |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel formulas
For example In D30 this formula
=IF($B$15="yes",F30,0) -- Regards Ron de Bruin http://www.rondebruin.nl "troy stud" wrote in message ... How do you do formula's, calculations? If the condition in b15 is yes, then the value in column d would change to whatever is in column F. If the condition is no, then there would be a 0? I'm unfamiliar with doing formula's. Thanx |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel formulas
=IF(B15="Yes",D15=F15,0)
-- Brevity is the soul of wit. "troy stud" wrote: How do you do formula's, calculations? If the condition in b15 is yes, then the value in column d would change to whatever is in column F. If the condition is no, then there would be a 0? I'm unfamiliar with doing formula's. Thanx |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel formulas
I see the formulas but how do they go into an excel sheet and how do they
work? It sounds like he wants to type a yes or no into b15 or maybe even d15? If the answer is yes, he wants d15 and f15 to match, such as 14,000, if it's no then 0 for an amount? "Dave F" wrote: =IF(B15="Yes",D15=F15,0) -- Brevity is the soul of wit. "troy stud" wrote: How do you do formula's, calculations? If the condition in b15 is yes, then the value in column d would change to whatever is in column F. If the condition is no, then there would be a 0? I'm unfamiliar with doing formula's. Thanx |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel formulas
That doesn't give the value of whatever is in column F, it gives a true or
false depending on whether D15 and F15 are equal (and of course it gives a circular reference if you put it in D15). Try Ron's formula. -- David Biddulph "Dave F" wrote in message ... =IF(B15="Yes",D15=F15,0) -- Brevity is the soul of wit. "troy stud" wrote: How do you do formula's, calculations? If the condition in b15 is yes, then the value in column d would change to whatever is in column F. If the condition is no, then there would be a 0? I'm unfamiliar with doing formula's. Thanx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel considers my formulas as plain text | Excel Worksheet Functions | |||
| How do you print showing formulas in Excel 2000? | Excel Discussion (Misc queries) | |||
| Please help with Statistics Formulas in Excel | Excel Discussion (Misc queries) | |||
| Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
| I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
Hybrid Mode
