I want to create a function that will put $25 in a cell if a cell is Y and 0 if it is No. How do I do that?
I want to create a function that will put $25 in a cell if a cell is Y and 0 if it is No. How do I do that?
in the particular cell type =if(YourCellHoldingValue ="Y", 25, 0)
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thank you so much!!!!! Just what I was looking for.
Here's another one...
=(A1="Y")*25
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks