Thread
:
If Then Else Formula for Excel Worksheet
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
If Then Else Formula for Excel Worksheet
You don't give many details but try something like:
=G6*LOOKUP(F6,{0,15000,25000,35000,45000},{0.05,0. 1,0.15,0.2,0.25})
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"pabell" wrote in message
...
I need a formula that evaluates a cell and if that cell is 15000 or below
the
spreadsheet multiples another cell by a certain percent, putting the
result
in the current cell, if the first cell is between 15001 and 25000 it
multiplies by another percent. This goes on for four total iterations.
Can
anyone help me?
--
-pbell
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann