Conditional Formula

Giganews Newsgroups
Subject: Conditional Formula
Posted by:  DeeExpus (DeeExpus.27ajrc_1146759604.592@excelforum-nospam.com)
Date: Thu, 4 May 2006

Hi all.
I have a spreadsheet which is basically a Hire Rate price list. I have
5 columns (1-6 week, 7 - 16 week etc etc) which I need to display the
cotents of. form looks like this:

HIRE PERIOD
5

QTY  DISC      1-6W  7-15W    16-31W    TOTAL
3    bla bla    £1.50  £1.00    £0.50        ???

sooo, I need the total to calculate the correct column*the quantity
basedon the amount of weeks in the Hire Period Cell.

Any Clue?

Cheers
Andy

--
DeeExpus
------------------------------------------------------------------------
DeeExpus's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34125
View this thread:http://www.excelforum.com/showthread.php?threadid=538952

Replies