Thread: Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Scott Scott is offline
external usenet poster
 
Posts: 14
Default Formula

I am trying to create the following formula:
if b2 is "no, then b6-b9, otherwise, b6-b9 but not less
than zero.

I think I have this correct until I get to the "but not
less than zero" part.

=if(b2="no",b6-b9,b6-b9 but not less than zero)

Thanks