View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Libby Libby is offline
external usenet poster
 
Posts: 151
Default 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.