Make IF return blank if FALSE

Sign-in

Sign-out

Last

QUESTION

ASK

RECENT

JOb

Forum Policy

Read:

Hide:

Show

Please input correctly

You are logined,Please click reply OR ask tag,USER_ID:

Server is busy or in error, if still in problem, please send us email at support@

HKSTOCK

Below area will not be traslated by Google,you can input code or other languages
paste code or other language below=>click Code(Run code, select all=>click STEP icon=>click Code)

Current Browser:

Update your Chrome/Edge to >=130.0.0.0 version
to get faster future/News data: Install/Update Chrome

This area is developing message box

News即時新聞:↓

更新

News即時新聞:↑

更新

On Balance Volume (OBV):

Option:

Youtube Video♬ Sharing by members:↓

Youtube Video♬ Sharing by members:↑

Ask Question Forum:

Model Library:2025-02-08 Updated:A.I. model is online for auto reply question page

Show

ASK RECENT

Make IF return blank if FALSE

Asked by Seamus2626

at 2024-11-15 05:15:53

Point:500 Replies:4 POST_ID:828789USER_ID:11690

Topic:

Microsoft Excel Spreadsheet Software;;

=IF(DX8="Yes",IF(DU8<DT8,"Risk Rated Down",IF(DU8>DT8,"Risk Rated Up",)))

Hi,

Can someone amend the above IF so it returns blank if FALSE

Many thanks
Seamus

Author: Seamus2626 replied at 2024-11-15 05:39:03

You too!

Expert: duncanb7 replied at 2024-11-15 05:34:24

Have a nice day and weekend, thanks

Author: Seamus2626 replied at 2024-11-15 05:24:05

Perfect, thanks Duncan

Accepted Solution

Expert: duncanb7 replied at 2024-11-15 05:21:33

500 points EXCELLENT

=IF(DX8="Yes",IF(DU8<DT8,"Risk Rated Down",IF(DU8>DT8,"Risk Rated Up","")),"")

Is that what you want about the blank if it is false ?

if not, please write it more your question or need

Duncan

Privacy Policy私隱政策

免責聲明：以上資料僅作參考之用
computer28.com對以上資訊的準性和可靠性不能亦不會作
任何保證或承擔，並對資料或有關的錯漏或延誤而作出的任何
決定或導致的損失概不負責.
Disclaimer: The above information is for reference only,
computer28.com cannot and will not provide any guarantee or
commitment for, and not responsible for any decision or loss
caused by the information or related errors,omissions or delays.

新聞財經娛樂♬資訊 News Economy

About Us|Service|Pricing

Stock Index全球即時指數期貨:

&nbps;

News即時新聞:↓

News即時新聞:↑

On Balance Volume (OBV):

Youtube Video♬ Sharing by members:↓

Youtube Video♬ Sharing by members:↑

Ask Question Forum:

Make IF return blank if FALSE

Your Information

Members/Profolio