| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Return a "" value from a formular
Any help greatly appreciated: I have 2 formulars that works, but I want them
to return nothing eg "" when there is nothing entered into a cell, at the moment they return the 'false' value. My formulars a =IF(O12O11,"End milestone deadline passed","OK") =IF(AND(O12O11,OR(D12D11,E12E11,F12F11,G12G11 ,H12H11,I12I11,J12J11,K12K11,L12L11,M12M11,N 12N11)),"End milestone passed and 'Actual's' late","End milestone passed but 'Actual's' OK") |
|
#2
|
|||
|
|||
|
=IF(isblank(O12),"",if(O12O11,"End milestone deadline passed","OK"))
=IF(isblank(O12),"",if(AND(O12O11,OR(D12D11,E12 E11,F12F11,G12G11,H12H1 1,I12I11,J12J11,K12K11,L12L11,M12M11,N12N11) ),"End milestone passed and 'Actual's' late","End milestone passed but 'Actual's' OK")) ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Gus" wrote in message ... Any help greatly appreciated: I have 2 formulars that works, but I want them to return nothing eg "" when there is nothing entered into a cell, at the moment they return the 'false' value. My formulars a =IF(O12O11,"End milestone deadline passed","OK") =IF(AND(O12O11,OR(D12D11,E12E11,F12F11,G12G11 ,H12H11,I12I11,J12J11,K 12K11,L12L11,M12M11,N12N11)),"End milestone passed and 'Actual's' late","End milestone passed but 'Actual's' OK") |
|
#3
|
|||
|
|||
|
one way is
=if(O12="","",your equation) "Gus" wrote: Any help greatly appreciated: I have 2 formulars that works, but I want them to return nothing eg "" when there is nothing entered into a cell, at the moment they return the 'false' value. My formulars a =IF(O12O11,"End milestone deadline passed","OK") =IF(AND(O12O11,OR(D12D11,E12E11,F12F11,G12G11 ,H12H11,I12I11,J12J11,K12K11,L12L11,M12M11,N 12N11)),"End milestone passed and 'Actual's' late","End milestone passed but 'Actual's' OK") |
|
#4
|
|||
|
|||
|
Many thanks, this worked with the 1st formular but not the 2nd. I also tried
the IF(isblank which worked for the 1st but not the 2nd "bj" wrote: one way is =if(O12="","",your equation) "Gus" wrote: Any help greatly appreciated: I have 2 formulars that works, but I want them to return nothing eg "" when there is nothing entered into a cell, at the moment they return the 'false' value. My formulars a =IF(O12O11,"End milestone deadline passed","OK") =IF(AND(O12O11,OR(D12D11,E12E11,F12F11,G12G11 ,H12H11,I12I11,J12J11,K12K11,L12L11,M12M11,N 12N11)),"End milestone passed and 'Actual's' late","End milestone passed but 'Actual's' OK") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - return a picture or range rows as the result of a formula | Excel Worksheet Functions | |||
| check if reference exists, then return its value or return 0 | Excel Worksheet Functions | |||
| How do create a formula to evalute a # to return 1 of 4 conditions | Excel Worksheet Functions | |||
| Using a Vlookup to return values in a data list? | Excel Worksheet Functions | |||
| if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
Hybrid Mode
