Hi All,
Is there a way to simpify the below IF formula? The formula output if true or false is very long and i'd like to avoid duplicating if possible
=if(A1="x",formula,formula*y)
Hi All,
Is there a way to simpify the below IF formula? The formula output if true or false is very long and i'd like to avoid duplicating if possible
=if(A1="x",formula,formula*y)
Last edited by Gti182; 05-26-2017 at 03:10 AM.
Hi- Try
=formula*IF(A1="x",1,y)
Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee
Maybe this?
=formula*if(A1="x",1,y)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
thanks both! Very clever
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks