Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
I am trying to set up a worksheet that will calculate up how much money I'm spending on people for thier christmas and birthdays this year (unfortunately they all come at once!). The english version of the formula I'm am trying to write is IF B3:B32 = "David" AND D3:D32= "Birthday" THEN K4 = sum of corresponding price in F3:F32. I have to admit I'm not very good with If and then statements but I understand the basics of programming. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I round prices to end in .95? | Excel Worksheet Functions | |||
Looking up prices | Excel Worksheet Functions | |||
prices | Excel Discussion (Misc queries) | |||
Look up a list of prices | Excel Worksheet Functions | |||
Use a multiplier to change List Prices to Net prices | Excel Worksheet Functions |