| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Logical Text Formula
What would the formula be if I want B12 to display the text of B07 if C07=Y?
|
|
#2
|
|||
|
|||
|
Hi
=IF(C7="Y",B7,"") -- Regards Frank Kabel Frankfurt, Germany "Jim" schrieb im Newsbeitrag ... What would the formula be if I want B12 to display the text of B07 if C07=Y? |
|
#3
|
|||
|
|||
|
=IF(CO7="Y",B07,"")
Regards, Peo Sjoblom "Jim" wrote: What would the formula be if I want B12 to display the text of B07 if C07=Y? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) | |||
| Is there a formula to convert numbers to written text in Excel? | Excel Worksheet Functions | |||
| Display numbers only, no text formula | Excel Worksheet Functions | |||
Linear Mode
