| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Formulas for One Cell Using IF
Thank you, that worked fine!
-- Andrew C "PCLIVE" wrote: One way, =IF(A1="",(B1-D1)/D1,(A1-C1)/C1) HTH, Paul "Andrew C" wrote in message ... Hello, I am having a time with this one. I am close, but just can't get there. I have 5 columns A, B, C, D, and E. If A1 has a value, E1 would equal (A1-C1)/C1. If B1 has a value, E1 would equal (B1-D1)/D1. If column A has a value, C will not and vice-versa. How would I do a formula for this? I appreciate any help in this. Thank you, -- Andrew C |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing cell references in formulas to names and back again. | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Hybrid Mode
