If the sum of a cell is a certain text then a dollar amount populates another cell

**avidcat** · 09-05-2009, 10:54 AM

Attached is an example. Office 2007 & 97 versions attached.

If a drop down menu on one sheet selects a certain word, then on another sheet based on that selection a dollar amount is entered.

I am guessing this would involve some if commands, I am really weak on making those and would appreciate some help.

Thanks,
Nick

**zbor** · 09-05-2009, 10:59 AM

Something like this?

=IF('Location Sheet'!C3:D3="Location #1";100000;IF('Location Sheet'!C3:D3="Location #2";250000;"Choose location"))

(change ; to , if needed and also format cell as currency $)

**avidcat** · 09-10-2009, 05:40 AM

Thanks, been busy and did not get back to this thread. That worked with the ","

I appreciate your help.

Nick

If the sum of a cell is a certain text then a dollar amount populates another cell

LinkBack

Thread Tools

Rate This Thread

Display

If the sum of a cell is a certain text then a dollar amount populates another cell

Re: If the sum of a cell is a certain text then a dollar amount populates another cel

Re: If the sum of a cell is a certain text then a dollar amount populates another cel

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions