Solved

Make IF return blank if FALSE

Posted on 2013-11-15
4
197 Views
Last Modified: 2013-11-15
=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
0
Comment
Question by:Seamus2626
  • 2
  • 2
4 Comments
 
LVL 13

Accepted Solution

by:
duncanb7 earned 500 total points
ID: 39651038
=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
0
 

Author Closing Comment

by:Seamus2626
ID: 39651045
Perfect, thanks Duncan
0
 
LVL 13

Expert Comment

by:duncanb7
ID: 39651064
Have a nice day and weekend, thanks
0
 

Author Comment

by:Seamus2626
ID: 39651082
You too!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question