pankajgrover
Board Regular
- Joined
- Oct 27, 2022
- Messages
- 99
- Office Version
- 365
- Platform
- Windows
Finally perfectly working, ThanksTry in R10
Excel Formula:=IFERROR(N(Q23)*IF(M23="",G23,M23)*N(B23)-N(O23),"")
Cell Formulas | ||
---|---|---|
Range | Formula | |
O27:O28 | O27 | =IF(AND(N27<>"",H27<>""),C27*M27,0) |
R27:R28 | R27 | =Q27*IF(M27="",G27,M27)*B27-O27 |
T27:T28 | T27 | =IF(E27="","",LEN(TRIM(E27))-LEN(SUBSTITUTE(E27," ",""))+1) |
U27:U28 | U27 | =IF(ISNUMBER(SEARCH(U$2,$E27)),$R27/$T27,"") |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
U3:AC99 | Cell Value | <0 | text | NO |
U3:AC99 | Cell | does not contain a blank value | text | NO |
Thanks working now. Before i apply your formula not working, and after i look and i found that O column has values behinds 0 instead of blank so i edit your formula O28=0 instead of "" and its now working good. Thanks .Try
Excel Formula:=IF(OR(ISBLANK(O28),O28=""),"",IF(ISNUMBER(SEARCH(U$2,$E28)),$R28/$T28,""))
hi @Sufiyan97 as per your formula which is proper working =IF(OR(ISBLANK(O28),O28=""),"",IF(ISNUMBER(SEARCH(U$2,$E28)),$R28/$T28,""))Thanks working now. Before i apply your formula not working, and after i look and i found that O column has values behinds 0 instead of blank so i edit your formula O28=0 instead of "" and its now working good. Thanks .
Thanks for example for easy understanding .Actually you can work without OR and ISBLANK
See for ISBLANK and "" results
Cell Formulas Range Formula A2 A2 ="" B2:B3 B2 =ISBLANK(A2) C2:C3 C2 =A2=""
So using just "" is fine, no need for ISBLANK.