ExcelBanter - How do I write an "if" formula??? See below......

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I write an "if" formula??? See below...... (https://www.excelbanter.com/excel-worksheet-functions/223167-how-do-i-write-if-formula-see-below.html)

Danno[_2_]

How do I write an "if" formula??? See below......

if(U10="F")leave this cell (where the formula is) blank?? Not enter a
zero.....just leave that cell empty. All help will be greatly appreciated.
Thanks!

Mike H

How do I write an "if" formula??? See below......

Maybe

=IF(U10="F","",U10)

or

=IF(U10="F",U10,"")

Mike

"Danno" wrote:

if(U10="F")leave this cell (where the formula is) blank?? Not enter a
zero.....just leave that cell empty. All help will be greatly appreciated.
Thanks!

All times are GMT +1. The time now is 05:39 AM.