IF statement of 2 Sums Based on a Cell Value

[whiterosetools]

I am wanting a cell to choose which sum to apply if a value is less than a number in a cell.

For example

D1 value is 12.5

IF D1 >12.5 then I need this calculation =SUM(Postage!$F$5*Prices!E1+Postage!$F$4)
IF D1 <12.5 then I need this calculation =SUM(Postage!$L$11*Prices!E1+Postage!$L$10)

Any help would be much appreciated.

Thank you in advance
Luke

[Naveed Raza]

have a look something like this...

Please Login or Register  to view this content.

[polkev]

solution depends on one thing. What happens if D1 = 12.5?

[whiterosetools]

Naveed - That formula is just coming up with VALUE. I suppose the formula wouldn't know which of the 2 formulas to use?

polkev - This would need to use the upper formula

Thanks
Luke

[boopathiraja]

Hi, try

Please Login or Register  to view this content.

[whiterosetools]

boopathiraja - This is still coming up with VALUE - I don't need D1 * the sum. I need the formula to choose the correct some based on D1 value.

Thank you.
Luke

[boopathiraja]

Hi, try

Please Login or Register  to view this content.

[whiterosetools]

boopathiraja - That's spot on. Thank you very much for your help. It's much appreciated.

Cheers
Luke

[boopathiraja]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[Naveed Raza]

Naveed - That formula is just coming up with VALUE. I suppose the formula wouldn't know which of the 2 formulas to use?

polkev - This would need to use the upper formula

Thanks
Luke

Hi Luke

I think same function i also provide u only >= is misssed

Please Login or Register  to view this content.