| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using IF function to perform calculation after specific date
I am having problems with the following formaula.
=IF(K2=0, "0",IF(E230/11/2008,O2*(15/115),O2*(175/1175))) I want a cell to display 0 if K2=0. If K2 doesn't equal 0, I want excel to perform one of two calculations using a vlaue in O2 depending on what date is in E2. If the date is prior to 30 Novemeber 2008 I want excel to perform O2*(175/1175). If the date is after 30 November 2008 then I want excel to perform O2*(15/115). Currently excel sometimes uses the wrong calculation as it doesn't recognise '30/11/2008' as a date but as a calculation i.e 30 divided by 11 divided by 2008. The issue is that I want Excel to recognise '30/11/2008' as the date, 30 November 2008, and not 30 divided by 11 divided by 2008. Is there any way that I can get excel to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A specific date used for calculation of a new date | Excel Discussion (Misc queries) | |||
| How do I perform calculation within IF statement? | Excel Worksheet Functions | |||
| perform 1 function, stop, perform different function | Excel Discussion (Misc queries) | |||
| perform calculation only if current time is after 10 am | Excel Worksheet Functions | |||
| How do I perform a contains function for a specific cell? | Excel Worksheet Functions | |||
Threaded Mode
