ExcelBanter - Ignore formula

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Ignore formula (https://www.excelbanter.com/excel-programming/393691-ignore-formula.html)

Arnie

Ignore formula

how do i ignore a formula in B1 if A1's contents is equal to "No"

thanks in advance

Niek Otten

Ignore formula

In B1:

=IF(A1="No","",YourOriginalFormula)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Arnie" wrote in message ...
| how do i ignore a formula in B1 if A1's contents is equal to "No"
|
| thanks in advance

All times are GMT +1. The time now is 09:07 AM.