Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default IF with Equal to or Greater than

Okay, what am I doing wrong? B3 and C3 are being added properly, but when it
gets to the IF function it will only add C3*.01 to that total regardless of
how high I set the value in D3.

=(B3+C3)+IF(D3=0.1,C3*0.01,IF(D3=0.2,C3*0.015,IF (D3=0.3,C3*0.02,IF(D3=0.4,C3*0.025,IF(D3=0.5,C3 *0.03)))))

Thank you
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 158
Default IF with Equal to or Greater than

You have to invert your values - start with highest to lowest, rather
than the order you have it.

IF D3 0.3, it is also true that it is 0.1

On May 1, 1:58*pm, sonicj wrote:
Okay, what am I doing wrong? *B3 and C3 are being added properly, but when it
gets to the IF function it will only add C3*.01 to that total regardless of
how high I set the value in D3. * *

=(B3+C3)+IF(D3=0.1,C3*0.01,IF(D3=0.2,C3*0.015,IF (D3=0.3,C3*0.02,IF(D3=0*.4,C3*0.025,IF(D3=0.5,C 3*0.03)))))

Thank you


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 158
Default IF with Equal to or Greater than

Just to be more clear -

It sees the 0.1, recognizes that it is true before it even gets to
the 0.3 IF statement and completes your equation based on that.

On May 1, 2:05*pm, wrote:
You have to invert your values - start with highest to lowest, rather
than the order you have it.

IF D3 0.3, it is also true that it is 0.1

On May 1, 1:58*pm, sonicj wrote:



Okay, what am I doing wrong? *B3 and C3 are being added properly, but when it
gets to the IF function it will only add C3*.01 to that total regardless of
how high I set the value in D3. * *


=(B3+C3)+IF(D3=0.1,C3*0.01,IF(D3=0.2,C3*0.015,IF (D3=0.3,C3*0.02,IF(D3=0**.4,C3*0.025,IF(D3=0.5, C3*0.03)))))


Thank you- Hide quoted text -


- Show quoted text -


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default IF with Equal to or Greater than

Perfect! Thank you.
=(B3+C3)+IF(D3=0.5,C3*0.03,IF(D3=0.4,C3*0.025,IF (D3=0.3,C3*0.02,IF(D3=0.2,C3*0.015,IF(D3=0.1,C3 *0.01)))))

" wrote:

You have to invert your values - start with highest to lowest, rather
than the order you have it.

IF D3 0.3, it is also true that it is 0.1

On May 1, 1:58 pm, sonicj wrote:
Okay, what am I doing wrong? B3 and C3 are being added properly, but when it
gets to the IF function it will only add C3*.01 to that total regardless of
how high I set the value in D3.

=(B3+C3)+IF(D3=0.1,C3*0.01,IF(D3=0.2,C3*0.015,IF (D3=0.3,C3*0.02,IF(D3=0Â*.4,C3*0.025,IF(D3=0.5, C3*0.03)))))

Thank you



  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 158
Default IF with Equal to or Greater than

Glad to be of service!

On May 1, 3:35*pm, sonicj wrote:
Perfect! *Thank you.
=(B3+C3)+IF(D3=0.5,C3*0.03,IF(D3=0.4,C3*0.025,IF (D3=0.3,C3*0.02,IF(D3=0*.2,C3*0.015,IF(D3=0.1,C 3*0.01)))))



" wrote:
You have to invert your values - start with highest to lowest, rather
than the order you have it.


IF D3 0.3, it is also true that it is 0.1


On May 1, 1:58 pm, sonicj wrote:
Okay, what am I doing wrong? *B3 and C3 are being added properly, but when it
gets to the IF function it will only add C3*.01 to that total regardless of
how high I set the value in D3. * *


=(B3+C3)+IF(D3=0.1,C3*0.01,IF(D3=0.2,C3*0.015,IF (D3=0.3,C3*0.02,IF(D3=0**.4,C3*0.025,IF(D3=0.5, C3*0.03)))))


Thank you- Hide quoted text -


- Show quoted text -


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Greater Than/Equal To Formula Millington Excel Discussion (Misc queries) 4 June 17th 07 04:51 AM
Greater than or equal to (Plus or minus) Brandon Excel Discussion (Misc queries) 2 July 18th 06 11:34 PM
First occurance greater than or equal to a specified value [email protected] Excel Worksheet Functions 3 February 5th 06 08:34 AM
GREATER OR EQUAL TO BUT LESS THAN Problem using Sumproduct Ragdyer Excel Worksheet Functions 0 September 29th 05 05:39 AM
Vlookup but also equal to and greater than? dazman Excel Worksheet Functions 1 August 7th 05 05:59 PM


All times are GMT +1. The time now is 11:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"