View Single Post
stomachmonkey stomachmonkey is offline
The Unsettler
 
stomachmonkey's Avatar
 
Join Date: Dec 2002
Location: Lantanna TX
Posts: 23,885
Send a message via AIM to stomachmonkey
Sorry, I'm working on little sleep.

Here's the formula,

IF(j2=10,"=sum(19.99*.0875)",0)

This works, the only problem I have is when you replace "10" with text "NY" I get #NAME as the output and it almost feels like the cell is not formatted properly.
__________________
"I want my two dollars"
"Goodbye and thanks for the fish"
"Proud Member and Supporter of the YWL"
"Brandon Won"
Old 01-30-2007, 06:35 PM
  Pelican Parts Catalog | Tech Articles | Promos & Specials    Reply With Quote #6 (permalink)