- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- MULTIPLE CONDITIONS FORMULA

Subject: | MULTIPLE CONDITIONS FORMULA |

Posted by: | TLAngelo |

Date: | Mon, 1 May 2006 |

I am trying to write a formula that contains multiple conditions and I need

help. If column E is equal to column C+3, then I want it to take the total

of (E+F)-(C+D) and subtract 62.5/24... AND if column E is equal to column

C+1, then I want it to only subtract 14.5/24. The formula that I have now

inserts the word FALSE instead of a number.

Here is what I have so far:

=IF(C4+3=E4,(E4+F4)-(C4+D4)-(62.5/24),(E4+F4)-(C4+D4))=IF(C4+1=E4,(E4+F4)-(C4+D4)-(14.5/24),(E4+F4)-(C4+D4))

- RE: MULTIPLE CONDITIONS FORMULA posted by Jerry W. Lewis on Mon, 1 May 2006