PDA

View Full Version : Find and Replace of Formula Result



Rajeshkanna
05-25-2012, 02:15 AM
I want replace my formula result by using (Ctrl + F) or (Ctrl + H).

Ex) my worksheet contains

A1 = 5
A2 = 10
------
a3 = 15 (a1+a2)
------

a4 = 15
------
a5 = 0.00 (a3-a4)
------

Now, i am using (CtrlH) and replace 0.00 to Blank. its not accepting. Pls help to resolve this.:banghead:

Teeroy
05-25-2012, 04:50 AM
Change A5 formula to "=IF(+A3-A4=0, "", +A3-A4)".