Need a Function

  • Thread starter Thread starter akemeny
  • Start date Start date
A

akemeny

I currently have the following function calculating:

=IF(OR(AA7="",AD7<>""),"",TODAY()-(AA7+65))

AA7 and AD7 are date columns. The column they calculate in is AC7. So if
AA7 is zero then AC7 is zero. If AA7 has a date then AC7 should equal
AA7+65-the current date. But if AD7 has a date then AC7 should equal AD7-AA7
instead of calculating from the first portion.

With the current function its only placing a zero when AD7 has a date. How
can I modify the current function so that I also calculates correctly??
 
It didn't work. Excel stated that the formula had too many arguements for
the function.
 
That one didn't return an error, but it only calculates the first portion
regarding Column AA. I think it needs an or option because the way I can
explain it is:

if AA7 equals zero then AC7 equals zero, but if AA7 equals a date then AC7
equals Today minus AA7 plus 65. However, if AD7 equals a date then the
previous formula no longer calculates, instead AC7 would now equal AD7 minus
AA7.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

More than 3 Conditions??? 9
Nested IF 2
Suddenly cannot calculate functions or formulas in Excel 1
Need Help Organizing a Formula? 1
find text in a string formula 5
Help to Tame the "formula" beast, PLEASE? 2
Adding hh:mm times in a row as part of a "named" cell 2
Adding in a piece of logic to my complicated formula! 3

Back
Top