Formula Validation - Returning Description or $ Difference

**PERE** · 02-26-2013, 04:26 AM

Hi,

Am seeking help for a formula contained in cell AF4 as described below.

Y4 contains a current value
AB4 contains a proposed value
Z4 contains the difference between AB4 - Y4.

In AF4 I would like the formula to check that the value in Z4 is an Exact reflection of the difference between Y4 and AB4. If correct it can then return "Balanced" or the +ve or -ve $ difference.

Many Thanks,
PERE

**mahaveersomani** · 02-26-2013, 04:59 AM

use the formula...in AF4

=If (z4=0,"Balanced",z4)

Regards
CA Mahaveer Somani

**PERE** · 02-26-2013, 08:07 PM

This does not check the difference between Y4 and AB4 though? I need AF4 check the difference and if the result of the difference is "Balanced" with Z4.
ANy suggestions?

**benishiryo** · 02-26-2013, 08:36 PM

i thought you mentioned Z4 contains the difference of Y4 & AB4? so if:
Y4: 100
AB4: 120
Z4: 120 - 100

so, mahaveersomani's solution will give you 120-100 since Z4 is not 0. and you'll get 20. you can shorten slightly though if it's not confusing for you:
=IF(Z4,Z4,"Balance")

**mahaveersomani** · 02-27-2013, 12:34 AM

thanks benishiryo

and Mr. "PERE" If my formula does not working then plz upload a sample workbook with your expected output therefore we can understand what is your requirement...?

Regards
CA Mahaveer Somani