Hi Experts,
I'm using IF formula but the bottom row is showing the #value, I have tried If error formula but it is not working, any expert can help me.
Thanks in Advance.
Regards.
Aaru
Hi Experts,
I'm using IF formula but the bottom row is showing the #value, I have tried If error formula but it is not working, any expert can help me.
Thanks in Advance.
Regards.
Aaru
Post a sample workbook. See the yellow banner at the top of the page.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
we cant see whats in S3 or Z3 - better to use a sample spreadsheet - see yellow banner
The formula looks OK - it will depend if there is an ERROR in Z3
IFERROR should work
=IFERROR ( IF(,,,,,)) , "" )
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thanks, Etf, it is working now.
you are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks