| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If formula true result then divided into 2 columns
I am trying to write an If formula that tells me:
If the value is true then divide the total column by 34% and 66% and put each percent in a seperate cell. V13=IF(C13="Both", T12*0.66, T12*0) U13==IF(C13="Both", T12*0.34, T12*0) I did this it does not should an error but it basically says that b/c this formula is making that cell equal 0 so it will calculate 1 column correctly and the other will have a valueof a zero. Is there an IF THEN kind of statement...So aggrevating becuase I am so close. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| True number as the result to an If-Then function | Excel Discussion (Misc queries) | |||
| True number as the result to an If-Then function | Excel Discussion (Misc queries) | |||
| True number as the result to an If-Then function | Excel Discussion (Misc queries) | |||
| True number as the result to an If-Then function | Excel Discussion (Misc queries) | |||
| How do I highlight a formula result (IF statment=True) | Excel Worksheet Functions | |||
Threaded Mode
