I need a formula to calculate Q4-R4 if R4 is not blank, if R4 is blank than show Q4?

**Mr.Castle** · 10-21-2018, 12:47 PM

**Fluff13** · 10-21-2018, 12:50 PM

Try
=IF(R4="",Q4,Q4-R4)

**Mr.Castle** · 10-21-2018, 12:57 PM

The formula worked,
Thank you

**joeu2004** · 10-21-2018, 01:02 PM

Another way:

=Q4-N(R4)

The N() function returns zero if R4 is empty or R4 appears blank because its value is the null string ("") or any other text.

**Fluff13** · 10-21-2018, 01:05 PM

Originally Posted by Mr.Castle

The formula worked,
Thank you

You're welcome

I need a formula to calculate Q4-R4 if R4 is not blank, if R4 is blank than show Q4?

LinkBack

Thread Tools

Rate This Thread

Display

I need a formula to calculate Q4-R4 if R4 is not blank, if R4 is blank than show Q4?

Re: I need a formula to calculate Q4-R4 if R4 is not blank, if R4 is blank than show Q4?

Re: I need a formula to calculate Q4-R4 if R4 is not blank, if R4 is blank than show Q4?

Re: I need a formula to calculate Q4-R4 if R4 is not blank, if R4 is blank than show Q4?

Re: I need a formula to calculate Q4-R4 if R4 is not blank, if R4 is blank than show Q4?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Dragging formula to add two columns, but need to show blank when other cell is blank

[SOLVED] Formula to show blank if two cells are blank

[SOLVED] Reference cell formula returning 0 when BLANK, need BLANK to show

[SOLVED] can month number helper column show blank if the corresponding date is blank.

Averaging with a blank cell, needs to show blank calculation

[SOLVED] Linking spreadsheets, want blank to appear as blank (blanks show as 00-Jan-00)

Excel 2007 : Reference Cell is blank, want Vlookup to show either blank or zero

Bookmarks

Bookmarks

Posting Permissions