View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Formula for: If b6 is or = to 8333 then b6 should be 8333 HELP

You can't do this with a formula. If B6 is a value, you cannot put a formula
in there. You need to add it do a different cell.

=IF(B 6=8333,8333,"what should I use if less than?")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Help Me" <Help wrote in message
...
Please help with this formual before I pull out my hair :) Also, there is

a
formula in b6.