Many Condition with IF Function

**Aumkar** · 07-30-2010, 06:26 AM

Originally Posted by arthurbr

Maybe =CEILING(F2,5000)*.01%

Thanks, this works

**DonkeyOte** · 07-30-2010, 06:29 AM

Given the <= operator the CEILING formula you've been given does exactly what you ask.

The formula takes the value in F2 and rounds up to next nearest multiple of 5000 - and then multiplies that final value by 0.01%

Please test before disregarding based on interpretation.

**Aumkar** · 07-30-2010, 06:38 AM

Sorry! I tested, but while writing the message here wrote something else.

It was my mistake that i was not able to state the problem correctly in the last post. Pardon me.
I was about to ask, what modification to the formula shall be made so that it takes into account the < condition and not <=.

**DonkeyOte** · 07-30-2010, 07:19 AM

see post # 2

**Aumkar** · 07-30-2010, 07:31 AM

Hi
I am looking for a formula which calculates value according to the following condition.
Here is a rough formula of what i am looking for:-

=IF(F2<5000, (5000*0.01%), "", IF(F2>5000 BUT <10000, (10000*.01%), "" ))

The same thing goes on with multiples of 5000. [IF greater than 10000 but less than 15000, then 15000*0.01%, IF greater than 15000 but less than 20000, then 20000*0.01% .........]

-Thanks

**DonkeyOte** · 07-30-2010, 07:43 AM

yet again, see post # 2

**Aumkar** · 07-30-2010, 08:08 AM

Thanks for both of the formula and sorry for asking the same question again and again

Many Condition with IF Function

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Many Condition with IF Function

Re: Many Condition with IF Function

Re: Many Condition with IF Function

Re: Many Condition with IF Function

Re: Many Condition with IF Function

Re: Many Condition with IF Function

Re: Many Condition with IF Function

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions