remmargorp
New Member
- Joined
- Oct 5, 2005
- Messages
- 20
Hey All,
Ive been working on a spreadsheet which involved me working out the rate of a certain object.
The user inputs the Width of a certain object and the Rate is determined by how long it is. Rate = $/metre.
The following code determines the higher the width the higher the price. basiccaly ive referenced the code to another sheet which contains the rates/widths so that the user can change the ratings.
What im stuck in doing is making the cell Null when there is no width imputed. I normally use an if statement like =IF(A1="","",[statement])
but when doing so on this [statement]..
=IF(F8="SS",IF(D8<=Pricing!$B$13,Pricing!$C$13,IF(D8<=Pricing!$B$14,Pricing!$C$14,IF(D8<=Pricing!$B$15,Pricing!$C$15,IF(D8<=Pricing!$B$16,Pricing!$C$16,IF(D8<=Pricing!$B$17,Pricing!$C$17,IF(D8<=Pricing!$B$18,Pricing!$C$18,IF(D8<=Pricing!$B$19,Pricing!$C$19))))))),IF(D8<=Pricing!$B$23,Pricing!$C$23,IF(D8<=Pricing!$B$24,Pricing!$C$24,IF(D8<=Pricing!$B$25,Pricing!$C$25,IF(D8<=Pricing!$B$26,Pricing!$C$26,IF(D8<=Pricing!$B$27,Pricing!$C$27,IF(D8<=Pricing!$B$28,Pricing!$C$28)))))))
it doesnt work and im stuck in why...
PLease help me cause its a project i need done asap
thnx in advance
Cheers
Chris
Ive been working on a spreadsheet which involved me working out the rate of a certain object.
The user inputs the Width of a certain object and the Rate is determined by how long it is. Rate = $/metre.
The following code determines the higher the width the higher the price. basiccaly ive referenced the code to another sheet which contains the rates/widths so that the user can change the ratings.
What im stuck in doing is making the cell Null when there is no width imputed. I normally use an if statement like =IF(A1="","",[statement])
but when doing so on this [statement]..
=IF(F8="SS",IF(D8<=Pricing!$B$13,Pricing!$C$13,IF(D8<=Pricing!$B$14,Pricing!$C$14,IF(D8<=Pricing!$B$15,Pricing!$C$15,IF(D8<=Pricing!$B$16,Pricing!$C$16,IF(D8<=Pricing!$B$17,Pricing!$C$17,IF(D8<=Pricing!$B$18,Pricing!$C$18,IF(D8<=Pricing!$B$19,Pricing!$C$19))))))),IF(D8<=Pricing!$B$23,Pricing!$C$23,IF(D8<=Pricing!$B$24,Pricing!$C$24,IF(D8<=Pricing!$B$25,Pricing!$C$25,IF(D8<=Pricing!$B$26,Pricing!$C$26,IF(D8<=Pricing!$B$27,Pricing!$C$27,IF(D8<=Pricing!$B$28,Pricing!$C$28)))))))
it doesnt work and im stuck in why...
PLease help me cause its a project i need done asap
thnx in advance
Cheers
Chris