Using IF(ISNUMBER with OR

[VCDTF191]

Ok. So Im creating a spreadsheet to track vacation time for my employees. I have three columns in question; C: AMOUNT RECEIVED, E: AMOUNT DEDUCTED and I: BALANCE. Im wanting to create a formula that leaves the cell in BALANCE blank, unless a value is entered into C: or E:, and if a value is entered into one of those columns then the BALANCE column will add the value from C: or subtract the value from E:.

This is the formula I am using to accomplish this only taking into account IF a value is entered into E:, but I dont know how to take into account C: and E: at the same time:

=IF(AND(ISNUMBER(E11)), I10+E11, "")

Any help would be greatly appreciated!

[FDibbins]

Hi, welcome to the forum

Because you said "value" entered into C or E, try this...
=IF(C11+E11=0,"",I10+E11)

If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[Special-K]

Try
=IF(OR(C1<>"",E1<>""),I10+E11,"")

You mention column C but its nowehere in your formula so base something on the above.

[VCDTF191]

Here is a sample of what Im working with. Again, my goal is to leave the BALANCE column blank, unless a value is entered into the RECEIEVD or DEDUCTED columns, and if a value is added to either one of those columns, then display the balance in the corresponding row under the BALANCE column

[Jonmo1]

Try this in I9 and filled down.

=IF(COUNT(C9,E9),I8+C9-E9,"")

[VCDTF191]

On the money!!! Thank you very much, you just relieved my headache instantly!

[Jonmo1]

You're welcome.