Help with IF
I've used the following to calculate a multiplied unit cost per kilo with a
minimum charge of 194. =IF(B2<100,194,B2*1.94) Now I want to allow a lower charge of 1.84 for multiples over 999 in the same cell. I've tried (guessed!!) the following but to no avail. =IF({b2<100,194,b2*1.94},{b2999,b2*1.84}) Would appreciate any suggestions -- kinsey |
Help with IF
This assumes that 1000 would be 1840
=IF(B2<100,194,IF(B2999,B2*1.84,B2*1.94)) as against 999 @ 1.94 and the rest at 1.84 -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "kinsey" wrote in message ... I've used the following to calculate a multiplied unit cost per kilo with a minimum charge of 194. =IF(B2<100,194,B2*1.94) Now I want to allow a lower charge of 1.84 for multiples over 999 in the same cell. I've tried (guessed!!) the following but to no avail. =IF({b2<100,194,b2*1.94},{b2999,b2*1.84}) Would appreciate any suggestions -- kinsey |
Help with IF
Bob, this works well. Many thanks!
-- kinsey "Bob Phillips" wrote: This assumes that 1000 would be 1840 =IF(B2<100,194,IF(B2999,B2*1.84,B2*1.94)) as against 999 @ 1.94 and the rest at 1.84 -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "kinsey" wrote in message ... I've used the following to calculate a multiplied unit cost per kilo with a minimum charge of 194. =IF(B2<100,194,B2*1.94) Now I want to allow a lower charge of 1.84 for multiples over 999 in the same cell. I've tried (guessed!!) the following but to no avail. =IF({b2<100,194,b2*1.94},{b2999,b2*1.84}) Would appreciate any suggestions -- kinsey |
All times are GMT +1. The time now is 05:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com