| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Returning a value rather than TRUE or FALSE.
I have a formula that seems to be working OK. It is If H14 ="",and Cond 1 OR
condit 2 Or Cond 3 are met, then return the actual value from G14, otherwise return the value from H14. When H14 is blank, and any of the OR conditions are met, it returns "TRUE"...How can I get it to return the actual value that is in G14, rather than "TRUE"? Thanks -- Rich D Armstrong Custom Homes Redmond |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Returning a value rather than TRUE or FALSE.
Post the formula so we can see what your OR conditions are.
Basically, it sounds like you need something like this: =IF(AND(H14="",OR(Cond1,Cond2,Cond3)),G14,H14) -- Biff Microsoft Excel MVP "Rich D" wrote in message ... I have a formula that seems to be working OK. It is If H14 ="",and Cond 1 OR condit 2 Or Cond 3 are met, then return the actual value from G14, otherwise return the value from H14. When H14 is blank, and any of the OR conditions are met, it returns "TRUE"...How can I get it to return the actual value that is in G14, rather than "TRUE"? Thanks -- Rich D Armstrong Custom Homes Redmond |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Returning a value rather than TRUE or FALSE.
=IF(AND(H14 ="",OR(Cond1,Cond2,Cond3)),G14,H14)
-- __________________________________ HTH Bob "Rich D" wrote in message ... I have a formula that seems to be working OK. It is If H14 ="",and Cond 1 OR condit 2 Or Cond 3 are met, then return the actual value from G14, otherwise return the value from H14. When H14 is blank, and any of the OR conditions are met, it returns "TRUE"...How can I get it to return the actual value that is in G14, rather than "TRUE"? Thanks -- Rich D Armstrong Custom Homes Redmond |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Returning a value rather than TRUE or FALSE.
Hi,
A bit difficult to unravel without your formula as an example but try this, =IF(H14<"",IF(OR(H14=1,H14=2,H14=3),G14,""),"") Mike "Rich D" wrote: I have a formula that seems to be working OK. It is If H14 ="",and Cond 1 OR condit 2 Or Cond 3 are met, then return the actual value from G14, otherwise return the value from H14. When H14 is blank, and any of the OR conditions are met, it returns "TRUE"...How can I get it to return the actual value that is in G14, rather than "TRUE"? Thanks -- Rich D Armstrong Custom Homes Redmond |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
| lookup returning true or false | Excel Discussion (Misc queries) | |||
| Search for 2 true arguments and return true or false | Excel Discussion (Misc queries) | |||
| Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
| Reverse false and combine with true true value | Excel Worksheet Functions | |||
Linear Mode
