Thread: Ignore formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default 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


Reply With QuoteReply With Quote