|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
Apr 15th, 2002, 06:08 PM
|
#1 |
|
New Member
Join Date: Mar 2002
Posts: 22
|
Hi, I need a single formula to do this please ......
If A1<6 then C1=D1, If A1>=6 but <9 then C1=D1+30% If A1>=9 then C1=D1+60% Hope that makes sense, it was the easiest way i could think of explaining what i need  ..oh yeah, no macros allowed  Thanks for your help as always. Anx [ This Message was edited by: Anx on 2002-04-15 17:09 ] |
|
|
|
Apr 15th, 2002, 06:30 PM
|
#2 |
|
Board Regular
Join Date: Feb 2002
Posts: 390
|
In C1 comes:
=IF(A1<6,D1,IF(A1>=9,D1*1.6,D1*1.3)) [ This Message was edited by: Albert 1 on 2002-04-15 17:31 ] |
|
|
|
|
Apr 15th, 2002, 06:32 PM
|
#3 |
|
Board Regular
Join Date: Mar 2002
Posts: 363
|
I'm assuming that the formula will be in cell C1. Here you go:
=if(A1<6,D1,if(A1<9,D1*1.3),D1*1.6)
__________________
It's never too late to learn something new. Ricky |
|
|
|
|
Apr 15th, 2002, 08:01 PM
|
#4 |
|
MrExcel MVP
Join Date: Mar 2002
Location: Chicago, IL USA
Posts: 2,042
|
How about:
=IF(A1>=9,1.6,IF(A1>=6,1.3,1))*D1 a little less typing. Jay |
|
|
|
|
Apr 15th, 2002, 09:48 PM
|
#5 |
|
New Member
Join Date: Mar 2002
Posts: 22
|
Thanks all
|
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
