Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting "odd" and "even" numbers
Hi!
I have data in the following format in say column A: A1: 1.0 A2: 1.5 A3: 2.0 A4: 2.5 A5: 3.0 etc. I'm trying to find out if it is possible with an IF statement of similar to do a calculation if the data is 1.0, 2.0 or 3.0. That is, I don't want to do a calculation if the data is 1.5, 2.5 etc. I tried the ISEVEN and ROUND functions without any luck. The problem shall solve price differences when you don't have even number of say doughnuts. If you sell 2 doughnuts you have the price for just two doughnuts. But if someone wants 2.5 doughnuts the price shall be calculated for 2.5 doughnuts and an additional split charge as well. 2 doughnuts - price = A3*price per doughnuts 2.5 doughnuts - price = A4*price per doughnuts + split charge Kind Regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation ?:Accepting both Numbers AND specific letters("N","n"," | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |