any MS Excell expert ? help needed.

[EmSpecial]

Hi PG members, basically i wanted to know that whether there is any way to put different formula for different values ?

for example in my company there are two different formulas to calculate the gross premium amount.
one is for values below 40,000 and one for values higher than 40,000.
i have prepared formula in excel for both above or below 40,000 gross. but i was wondering whether is there anyway i can just put formula and excel it self identify the value whether its below or higher than 40,000 and put the specific formula and calculate the figure ?

i am not sure whether i have clearly mentioned my point. do let me know if not clear.

 

[c0d3r]

Well, a simple IF() in Excel would solve it .. its not difficult too actually ...

For cell F3 for example, use this:
=IF(F3>40000,'formula1','formula2')

 

[abobobilly]

I am not sure if i understand your problem correctly. I might be able to help more accurately if i understand the nature of your work, or the details about the gross premium.

However, if there are any slabs, you can create a Master Data sheet, and make a table of Slab Rates.

Then later use "Vlookup" (or Index/Match) function to find that value in Master Data's Table.