| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Statements
Problem I have the set of data, Value Fee A B C Min Max £0.00 £4.99 £0.45 £5.00 £9.99 £0.85 £10.00 £99.99 £0.09 £100.00 £250.00 £8.75 I have used Vlookup to build the function. =IF(VLOOKUP(B12,$A$3:$C$7,3)=$C$5,$C$5*B12,VLOOKUP (B12,$A$3:$C$6,3)). What I am looking for is that when the value is over 250, it should divide it by 250 and return the rate appropriately. If it is nil it should return 0 Can someone help? Please find attached +-------------------------------------------------------------------+ |Filename: TropezfnPO Management.zip | |Download: http://www.excelforum.com/attachment.php?postid=4615 | +-------------------------------------------------------------------+ -- tropezfn ------------------------------------------------------------------------ tropezfn's Profile: http://www.excelforum.com/member.php...o&userid=33351 View this thread: http://www.excelforum.com/showthread...hreadid=531845 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating my own user defined function help statements | Excel Worksheet Functions | |||
| UDFunctions and nested If-the-else statements | Excel Worksheet Functions | |||
| Linking two IF statements together | Excel Discussion (Misc queries) | |||
| Logical ELSE statements | Excel Discussion (Misc queries) | |||
| Nested IF statements | Excel Worksheet Functions | |||
Threaded Mode
